/*
 Navicat Premium Dump SQL

 Source Server         : 本机mysql
 Source Server Type    : MySQL
 Source Server Version : 80040 (8.0.40)
 Source Host           : localhost:3306
 Source Schema         : sailor-console

 Target Server Type    : MySQL
 Target Server Version : 80040 (8.0.40)
 File Encoding         : 65001

 Date: 10/02/2025 09:45:22
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for casbin_rule
-- ----------------------------
DROP TABLE IF EXISTS `casbin_rule`;
CREATE TABLE `casbin_rule` (
  `uuid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `ptype` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `v0` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `v1` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `v2` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `v3` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `v4` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `v5` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records of casbin_rule
-- ----------------------------
BEGIN;
INSERT INTO `casbin_rule` (`uuid`, `ptype`, `v0`, `v1`, `v2`, `v3`, `v4`, `v5`) VALUES ('0af572d1-6fc6-435e-aff9-cc5288c6fdb6', 'p', 'super_admin', '/api/auth/task/create', 'POST', NULL, NULL, NULL);
INSERT INTO `casbin_rule` (`uuid`, `ptype`, `v0`, `v1`, `v2`, `v3`, `v4`, `v5`) VALUES ('0bb9f8d2-9582-44d3-aa50-d8111519294f', 'p', 'super_admin', '/api/auth/setting/role/list', 'GET', NULL, NULL, NULL);
INSERT INTO `casbin_rule` (`uuid`, `ptype`, `v0`, `v1`, `v2`, `v3`, `v4`, `v5`) VALUES ('0f7b60a1-d502-46e9-8b8f-df9846f2cd0f', 'p', 'super_admin', '/api/auth/user/menu', 'GET', NULL, NULL, NULL);
INSERT INTO `casbin_rule` (`uuid`, `ptype`, `v0`, `v1`, `v2`, `v3`, `v4`, `v5`) VALUES ('157a99cb-620e-452a-8098-eac5c7789740', 'p', 'super_admin', '/api/auth/setting/role/list/all', 'GET', NULL, NULL, NULL);
INSERT INTO `casbin_rule` (`uuid`, `ptype`, `v0`, `v1`, `v2`, `v3`, `v4`, `v5`) VALUES ('2918e490-103c-4bc9-919f-8e78b2a1701b', 'p', 'super_admin', '/api/auth/task/disable', 'GET', NULL, NULL, NULL);
INSERT INTO `casbin_rule` (`uuid`, `ptype`, `v0`, `v1`, `v2`, `v3`, `v4`, `v5`) VALUES ('2b1865d4-6bad-4627-b3d1-1057c552d5c9', 'p', 'super_admin', '/api/auth/setting/api/list', 'GET', NULL, NULL, NULL);
INSERT INTO `casbin_rule` (`uuid`, `ptype`, `v0`, `v1`, `v2`, `v3`, `v4`, `v5`) VALUES ('3268dcee-7749-4e3e-af69-c7b94031a2b0', 'p', 'super_admin', '/api/auth/task/delete', 'GET', NULL, NULL, NULL);
INSERT INTO `casbin_rule` (`uuid`, `ptype`, `v0`, `v1`, `v2`, `v3`, `v4`, `v5`) VALUES ('3a8ff8dd-a927-45ab-a850-4b1d87c05364', 'p', 'super_admin', '/api/auth/setting/role/permission/list', 'GET', NULL, NULL, NULL);
INSERT INTO `casbin_rule` (`uuid`, `ptype`, `v0`, `v1`, `v2`, `v3`, `v4`, `v5`) VALUES ('3b1f3741-dd20-4d8a-a4ba-03b873942dfb', 'p', 'super_admin', '/api/auth/setting/role/permission/update', 'POST', NULL, NULL, NULL);
INSERT INTO `casbin_rule` (`uuid`, `ptype`, `v0`, `v1`, `v2`, `v3`, `v4`, `v5`) VALUES ('42dc8a08-159f-49ac-9c68-4b96294ab6d2', 'p', 'super_admin', '/api/auth/task/update', 'POST', NULL, NULL, NULL);
INSERT INTO `casbin_rule` (`uuid`, `ptype`, `v0`, `v1`, `v2`, `v3`, `v4`, `v5`) VALUES ('4c20204a-3c5a-4ee7-abb4-d5b2cec8f757', 'p', 'super_admin', '/api/auth/task/enable', 'GET', NULL, NULL, NULL);
INSERT INTO `casbin_rule` (`uuid`, `ptype`, `v0`, `v1`, `v2`, `v3`, `v4`, `v5`) VALUES ('63d56397-a21a-4195-8ede-57158dd1e88f', 'p', 'super_admin', '/api/auth/task/list', 'GET', NULL, NULL, NULL);
INSERT INTO `casbin_rule` (`uuid`, `ptype`, `v0`, `v1`, `v2`, `v3`, `v4`, `v5`) VALUES ('6c069a4c-9f8f-4991-b8d2-4387663ccb87', 'p', 'user', '/api.v1/login', 'POST', NULL, NULL, NULL);
INSERT INTO `casbin_rule` (`uuid`, `ptype`, `v0`, `v1`, `v2`, `v3`, `v4`, `v5`) VALUES ('714745a6-864f-4b8d-a9b7-aa6dfe7729b1', 'p', 'super_admin', '/api/auth/setting/menu/update', 'POST', NULL, NULL, NULL);
INSERT INTO `casbin_rule` (`uuid`, `ptype`, `v0`, `v1`, `v2`, `v3`, `v4`, `v5`) VALUES ('73ffe5b5-1e1a-4318-8a45-d7112c371501', 'p', 'super_admin', '/api/auth/setting/user/list', 'GET', NULL, NULL, NULL);
INSERT INTO `casbin_rule` (`uuid`, `ptype`, `v0`, `v1`, `v2`, `v3`, `v4`, `v5`) VALUES ('749e0d04-eee5-422f-bdcf-02abf21540bf', 'p', 'super_admin', '/api/login', 'POST', NULL, NULL, NULL);
INSERT INTO `casbin_rule` (`uuid`, `ptype`, `v0`, `v1`, `v2`, `v3`, `v4`, `v5`) VALUES ('74b6a713-8735-496f-8ed5-1693cad1ae3c', 'p', 'super_admin', '/api/auth/task/log/delete', 'GET', NULL, NULL, NULL);
INSERT INTO `casbin_rule` (`uuid`, `ptype`, `v0`, `v1`, `v2`, `v3`, `v4`, `v5`) VALUES ('78e5f5ac-0f81-4d9f-b691-9883847dc32d', 'p', 'super_admin', '/api/auth/setting/user/delete', 'POST', NULL, NULL, NULL);
INSERT INTO `casbin_rule` (`uuid`, `ptype`, `v0`, `v1`, `v2`, `v3`, `v4`, `v5`) VALUES ('824a29d1-0f0a-4950-96e2-d8ff0d535eb2', 'p', 'super_admin', '/api/auth/setting/role/create', 'POST', NULL, NULL, NULL);
INSERT INTO `casbin_rule` (`uuid`, `ptype`, `v0`, `v1`, `v2`, `v3`, `v4`, `v5`) VALUES ('860393f3-a60b-42c2-a2db-3656ff29c481', 'p', 'super_admin', '/api/auth/setting/menu/create', 'POST', NULL, NULL, NULL);
INSERT INTO `casbin_rule` (`uuid`, `ptype`, `v0`, `v1`, `v2`, `v3`, `v4`, `v5`) VALUES ('8d3cc324-2c9e-4786-b15e-a7d22e9c42bc', 'p', 'user', '/api/auth/user/menu', 'GET', NULL, NULL, NULL);
INSERT INTO `casbin_rule` (`uuid`, `ptype`, `v0`, `v1`, `v2`, `v3`, `v4`, `v5`) VALUES ('8f4b8cae-69fd-46be-9fd8-43ca4abb2b37', 'p', 'super_admin', '/api/auth/setting/api/sync', 'GET', NULL, NULL, NULL);
INSERT INTO `casbin_rule` (`uuid`, `ptype`, `v0`, `v1`, `v2`, `v3`, `v4`, `v5`) VALUES ('9a404cf3-8449-45ed-a429-a76d94455fa3', 'p', 'super_admin', '/api/auth/setting/menu/list/all', 'GET', NULL, NULL, NULL);
INSERT INTO `casbin_rule` (`uuid`, `ptype`, `v0`, `v1`, `v2`, `v3`, `v4`, `v5`) VALUES ('b74cd686-cb1d-4081-a3ba-ca833ade80f2', 'p', 'super_admin', '/api/auth/task/run/one', 'GET', NULL, NULL, NULL);
INSERT INTO `casbin_rule` (`uuid`, `ptype`, `v0`, `v1`, `v2`, `v3`, `v4`, `v5`) VALUES ('b9744c28-2e0d-44d5-99ac-241590d07fcf', 'p', 'super_admin', '/api/auth/setting/user/change/role', 'POST', NULL, NULL, NULL);
INSERT INTO `casbin_rule` (`uuid`, `ptype`, `v0`, `v1`, `v2`, `v3`, `v4`, `v5`) VALUES ('ce81f535-8b2c-4465-ac9c-5a20ce33861a', 'p', 'super_admin', '/api/auth/setting/menu/delete', 'POST', NULL, NULL, NULL);
INSERT INTO `casbin_rule` (`uuid`, `ptype`, `v0`, `v1`, `v2`, `v3`, `v4`, `v5`) VALUES ('fd3fda3a-1c08-4361-8536-b2d0483c3fd0', 'p', 'super_admin', '/api/auth/setting/role/update', 'POST', NULL, NULL, NULL);
INSERT INTO `casbin_rule` (`uuid`, `ptype`, `v0`, `v1`, `v2`, `v3`, `v4`, `v5`) VALUES ('fe84a65e-face-48b0-8a34-76bc4b0c4b1b', 'p', 'super_admin', '/api/auth/task/log/list', 'GET', NULL, NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for sys_api
-- ----------------------------
DROP TABLE IF EXISTS `sys_api`;
CREATE TABLE `sys_api` (
  `uuid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'API唯一ID',
  `created_at` datetime(3) NOT NULL COMMENT '创建时间',
  `updated_at` datetime(3) DEFAULT NULL COMMENT '更新时间',
  `deleted_at` datetime(3) DEFAULT NULL COMMENT '删除时间',
  `api_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '接口路径',
  `api_method` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '请求方式',
  `api_description` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '接口描述',
  `api_group` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '接口所属组',
  PRIMARY KEY (`uuid`) USING BTREE,
  KEY `idx_sys_api_deleted_at` (`deleted_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records of sys_api
-- ----------------------------
BEGIN;
INSERT INTO `sys_api` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `api_path`, `api_method`, `api_description`, `api_group`) VALUES ('0194e9a7-9f5a-72a7-9a5a-fa15ad5250b3', '2025-02-09 15:41:04.218', '2025-02-09 15:41:04.218', NULL, '/api/auth/setting/api/list', 'GET', '分页获取接口列表', 'setting');
INSERT INTO `sys_api` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `api_path`, `api_method`, `api_description`, `api_group`) VALUES ('0194e9a7-9f5d-769b-909a-3f2cb4a0e1fa', '2025-02-09 15:41:04.222', '2025-02-09 15:41:04.222', NULL, '/api/auth/setting/api/sync', 'GET', '从内存同步API接口', 'setting');
INSERT INTO `sys_api` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `api_path`, `api_method`, `api_description`, `api_group`) VALUES ('0194e9a7-9f5f-718e-ba63-1b6c6ca34c9a', '2025-02-09 15:41:04.224', '2025-02-09 15:41:04.224', NULL, '/api/auth/setting/menu/create', 'POST', '创建菜单', 'setting');
INSERT INTO `sys_api` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `api_path`, `api_method`, `api_description`, `api_group`) VALUES ('0194e9a7-9f61-7451-8086-4d7469825d7c', '2025-02-09 15:41:04.225', '2025-02-09 15:41:04.225', NULL, '/api/auth/setting/menu/delete', 'POST', '删除菜单', 'setting');
INSERT INTO `sys_api` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `api_path`, `api_method`, `api_description`, `api_group`) VALUES ('0194e9a7-9f62-7148-9040-06b9f9a8a065', '2025-02-09 15:41:04.226', '2025-02-09 15:41:04.226', NULL, '/api/auth/setting/menu/list/all', 'GET', '不分页获取菜单列表', 'setting');
INSERT INTO `sys_api` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `api_path`, `api_method`, `api_description`, `api_group`) VALUES ('0194e9a7-9f63-7670-9546-86e01dac8576', '2025-02-09 15:41:04.228', '2025-02-09 15:41:04.228', NULL, '/api/auth/setting/menu/update', 'POST', '更新菜单信息', 'setting');
INSERT INTO `sys_api` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `api_path`, `api_method`, `api_description`, `api_group`) VALUES ('0194e9a7-9f64-7ac5-8d33-b109c77049bc', '2025-02-09 15:41:04.229', '2025-02-09 15:41:04.229', NULL, '/api/auth/setting/role/create', 'POST', '创建角色', 'setting');
INSERT INTO `sys_api` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `api_path`, `api_method`, `api_description`, `api_group`) VALUES ('0194e9a7-9f65-72f9-a099-994aa0872cee', '2025-02-09 15:41:04.229', '2025-02-09 15:41:04.229', NULL, '/api/auth/setting/role/list', 'GET', '分页获取角色列表', 'setting');
INSERT INTO `sys_api` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `api_path`, `api_method`, `api_description`, `api_group`) VALUES ('0194e9a7-9f65-7999-b158-63067a7ea107', '2025-02-09 15:41:04.230', '2025-02-09 15:41:04.230', NULL, '/api/auth/setting/role/list/all', 'GET', '不分页获取角色列表', 'setting');
INSERT INTO `sys_api` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `api_path`, `api_method`, `api_description`, `api_group`) VALUES ('0194e9a7-9f66-7505-b83c-a5ff80873b8c', '2025-02-09 15:41:04.230', '2025-02-09 15:41:04.230', NULL, '/api/auth/setting/role/permission/list', 'GET', '获取角色权限列表', 'setting');
INSERT INTO `sys_api` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `api_path`, `api_method`, `api_description`, `api_group`) VALUES ('0194e9a7-9f67-702a-be87-9062c91fd140', '2025-02-09 15:41:04.231', '2025-02-09 15:41:04.231', NULL, '/api/auth/setting/role/permission/update', 'POST', '更新角色权限列表', 'setting');
INSERT INTO `sys_api` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `api_path`, `api_method`, `api_description`, `api_group`) VALUES ('0194e9a7-9f68-75d4-ac6f-d9c930badd98', '2025-02-09 15:41:04.233', '2025-02-09 15:41:04.233', NULL, '/api/auth/setting/role/update', 'POST', '更新角色信息', 'setting');
INSERT INTO `sys_api` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `api_path`, `api_method`, `api_description`, `api_group`) VALUES ('0194e9a7-9f69-77a8-b35e-89e8ec708e91', '2025-02-09 15:41:04.234', '2025-02-09 15:41:04.234', NULL, '/api/auth/setting/user/change/role', 'POST', '修改用户角色', 'setting');
INSERT INTO `sys_api` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `api_path`, `api_method`, `api_description`, `api_group`) VALUES ('0194e9a7-9f69-7e6f-adb1-c8269259b29f', '2025-02-09 15:41:04.234', '2025-02-09 15:41:04.234', NULL, '/api/auth/setting/user/delete', 'POST', '删除用户', 'setting');
INSERT INTO `sys_api` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `api_path`, `api_method`, `api_description`, `api_group`) VALUES ('0194e9a7-9f6a-7a68-9c8f-25bc37bd3369', '2025-02-09 15:41:04.235', '2025-02-09 15:41:04.235', NULL, '/api/auth/setting/user/list', 'GET', '分页获取用户列表', 'setting');
INSERT INTO `sys_api` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `api_path`, `api_method`, `api_description`, `api_group`) VALUES ('0194e9a7-9f6b-760e-8a12-205e8205f663', '2025-02-09 15:41:04.235', '2025-02-09 15:41:04.235', NULL, '/api/auth/task/create', 'POST', '创建任务', 'task');
INSERT INTO `sys_api` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `api_path`, `api_method`, `api_description`, `api_group`) VALUES ('0194e9a7-9f6b-7d59-9903-a4e0c9784152', '2025-02-09 15:41:04.236', '2025-02-09 15:41:04.236', NULL, '/api/auth/task/delete', 'GET', '删除任务', 'task');
INSERT INTO `sys_api` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `api_path`, `api_method`, `api_description`, `api_group`) VALUES ('0194e9a7-9f6c-798d-b2a7-04a58cd2a862', '2025-02-09 15:41:04.237', '2025-02-09 15:41:04.237', NULL, '/api/auth/task/disable', 'GET', '禁止任务', 'task');
INSERT INTO `sys_api` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `api_path`, `api_method`, `api_description`, `api_group`) VALUES ('0194e9a7-9f6d-717a-aae8-43c54db0e2a8', '2025-02-09 15:41:04.237', '2025-02-09 15:41:04.237', NULL, '/api/auth/task/enable', 'GET', '激活任务', 'task');
INSERT INTO `sys_api` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `api_path`, `api_method`, `api_description`, `api_group`) VALUES ('0194e9a7-9f6e-7a54-af9a-1fce789c3e70', '2025-02-09 15:41:04.240', '2025-02-09 15:41:04.240', NULL, '/api/auth/task/list', 'GET', '分页获取任务列表', 'task');
INSERT INTO `sys_api` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `api_path`, `api_method`, `api_description`, `api_group`) VALUES ('0194e9a7-9f70-78e1-9d88-72657f562ebf', '2025-02-09 15:41:04.241', '2025-02-09 15:41:04.241', NULL, '/api/auth/task/log/delete', 'GET', '删除任务日志', 'task');
INSERT INTO `sys_api` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `api_path`, `api_method`, `api_description`, `api_group`) VALUES ('0194e9a7-9f71-71a5-af1b-3a890a85d46c', '2025-02-09 15:41:04.241', '2025-02-09 15:41:04.241', NULL, '/api/auth/task/log/list', 'GET', '分页获取任务日志列表', 'Api');
INSERT INTO `sys_api` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `api_path`, `api_method`, `api_description`, `api_group`) VALUES ('0194e9a7-9f73-722e-bbc4-1b50219f7417', '2025-02-09 15:41:04.243', '2025-02-09 15:41:04.243', NULL, '/api/auth/task/run/one', 'GET', '运行一次任务', 'task');
INSERT INTO `sys_api` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `api_path`, `api_method`, `api_description`, `api_group`) VALUES ('0194e9a7-9f74-7981-92bf-7732f92bbaa6', '2025-02-09 15:41:04.245', '2025-02-09 15:41:04.245', NULL, '/api/auth/task/update', 'POST', '修改任务信息', 'task');
INSERT INTO `sys_api` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `api_path`, `api_method`, `api_description`, `api_group`) VALUES ('0194e9a7-9f75-7334-b184-8ae9a14165db', '2025-02-09 15:41:04.245', '2025-02-09 15:41:04.245', NULL, '/api/auth/user/menu', 'GET', '获取用户菜单权限', 'user_menu');
INSERT INTO `sys_api` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `api_path`, `api_method`, `api_description`, `api_group`) VALUES ('0194e9a7-9f75-7b4e-80b9-1f4fb7f1d4ec', '2025-02-09 15:41:04.246', '2025-02-09 15:41:04.246', NULL, '/api/login', 'POST', '用户登录', 'login');
COMMIT;

-- ----------------------------
-- Table structure for sys_dictionaries
-- ----------------------------
DROP TABLE IF EXISTS `sys_dictionaries`;
CREATE TABLE `sys_dictionaries` (
  `uuid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '字典分类唯一ID',
  `created_at` datetime(3) NOT NULL COMMENT '创建时间',
  `updated_at` datetime(3) DEFAULT NULL COMMENT '更新时间',
  `deleted_at` datetime(3) DEFAULT NULL COMMENT '删除时间',
  `dic_name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '字典名称',
  `dic_code` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '字典编码',
  `dic_status` tinyint unsigned NOT NULL DEFAULT '1' COMMENT '字典状态,默认=1正常,=2停用',
  `dic_notes` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注',
  `dic_parent_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '父分类ID',
  PRIMARY KEY (`uuid`) USING BTREE,
  UNIQUE KEY `uni_sys_dict_type_name` (`dic_name`),
  UNIQUE KEY `uni_sys_dict_type_type` (`dic_code`),
  KEY `idx_sys_dict_type_deleted_at` (`deleted_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records of sys_dictionaries
-- ----------------------------
BEGIN;
INSERT INTO `sys_dictionaries` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `dic_name`, `dic_code`, `dic_status`, `dic_notes`, `dic_parent_id`) VALUES ('385863da-9cc1-11ef-ae8b-4aa14d9c28f0', '2024-11-07 09:21:20.097', '2024-11-07 09:21:20.097', NULL, '性别', 'sex', 1, '管理员/用户性别', NULL);
COMMIT;

-- ----------------------------
-- Table structure for sys_dictionaries_details
-- ----------------------------
DROP TABLE IF EXISTS `sys_dictionaries_details`;
CREATE TABLE `sys_dictionaries_details` (
  `uuid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '字典项唯一ID',
  `created_at` datetime(3) NOT NULL COMMENT '创建时间',
  `updated_at` datetime(3) DEFAULT NULL COMMENT '更新时间',
  `deleted_at` datetime(3) DEFAULT NULL COMMENT '删除时间',
  `dic_label` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '字典标签',
  `dic_value` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '字典值',
  `dic_status` tinyint unsigned NOT NULL DEFAULT '1' COMMENT '字典状态,默认=1正常,=2停用',
  `dic_notes` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注',
  `dic_parent_id` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '菜单分类ID',
  PRIMARY KEY (`uuid`) USING BTREE,
  KEY `idx_sys_dict_data_deleted_at` (`deleted_at`),
  KEY `idx_sys_dict_data_dict_type` (`dic_parent_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records of sys_dictionaries_details
-- ----------------------------
BEGIN;
INSERT INTO `sys_dictionaries_details` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `dic_label`, `dic_value`, `dic_status`, `dic_notes`, `dic_parent_id`) VALUES ('3ed93842-9cc1-11ef-ae8b-4aa14d9c28f0', '2024-11-07 09:21:20.098', '2024-11-07 09:21:20.098', NULL, '未知', '0', 1, '', 'sex');
INSERT INTO `sys_dictionaries_details` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `dic_label`, `dic_value`, `dic_status`, `dic_notes`, `dic_parent_id`) VALUES ('3ed95b60-9cc1-11ef-ae8b-4aa14d9c28f0', '2024-11-07 09:21:20.098', '2024-11-07 09:21:20.098', NULL, '男', '1', 1, '', 'sex');
INSERT INTO `sys_dictionaries_details` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `dic_label`, `dic_value`, `dic_status`, `dic_notes`, `dic_parent_id`) VALUES ('3ed95d7c-9cc1-11ef-ae8b-4aa14d9c28f0', '2024-11-07 09:21:20.098', '2024-11-07 09:21:20.098', NULL, '女', '2', 1, '', 'sex');
COMMIT;

-- ----------------------------
-- Table structure for sys_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_menu`;
CREATE TABLE `sys_menu` (
  `uuid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '菜单唯一ID',
  `created_at` datetime(3) DEFAULT NULL COMMENT '创建时间',
  `updated_at` datetime(3) DEFAULT NULL COMMENT '更新时间',
  `deleted_at` datetime(3) DEFAULT NULL COMMENT '删除时间',
  `menu_parent_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '父菜单路由ID',
  `menu_sort` tinyint unsigned DEFAULT '0' COMMENT '排序标记',
  `path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '菜单路由路径',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '菜单组件名称,如果菜单类型为按钮，此为按钮标识',
  `redirect` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '菜单路由重定向地址',
  `component` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '菜单路由文件所在地址',
  `icon` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '菜单图标',
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '菜单标题',
  `active` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '菜单栏高亮,默认激活菜单的',
  `type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '菜单类型BUTTON,MENU',
  `isHide` tinyint unsigned DEFAULT '0' COMMENT '菜单是否隐藏0假1真',
  `isFull` tinyint unsigned DEFAULT '0' COMMENT '菜单是否全屏0假1真',
  `isAffix` tinyint unsigned DEFAULT '0' COMMENT '菜单前置且不可关闭0假1真',
  `isKeepAlive` tinyint unsigned DEFAULT '0' COMMENT '菜单是否缓存页面0假1真',
  `tag` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '菜单tag标签',
  PRIMARY KEY (`uuid`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records of sys_menu
-- ----------------------------
BEGIN;
INSERT INTO `sys_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `menu_parent_id`, `menu_sort`, `path`, `name`, `redirect`, `component`, `icon`, `title`, `active`, `type`, `isHide`, `isFull`, `isAffix`, `isKeepAlive`, `tag`) VALUES ('0194ba2c-26a1-7d0b-bd0c-1bf095cd4f0b', '2025-01-31 10:24:03.234', '2025-01-31 10:24:03.234', NULL, '0194b8b7-a834-7e77-99bd-c37d79f40853', 0, '/Fri Jan 31 2025 10:24:03 GMT+0800 (中国标准时间)', '未命名Fri Jan 31 2025 10:24:03 GMT+0800 (中国标准时间)', NULL, '', NULL, '未命名Fri Jan 31 2025 10:24:03 GMT+0800 (中国标准时间)', NULL, 'menu', 0, 0, 0, 0, NULL);
INSERT INTO `sys_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `menu_parent_id`, `menu_sort`, `path`, `name`, `redirect`, `component`, `icon`, `title`, `active`, `type`, `isHide`, `isFull`, `isAffix`, `isKeepAlive`, `tag`) VALUES ('0194ba2c-548b-720f-ae0f-a4fac4c72ffb', '2025-01-31 10:24:14.987', '2025-01-31 10:24:17.817', NULL, '0194b8b7-a834-7e77-99bd-c37d79f40853', 0, '/Fri Jan 31 2025 10:24:14 GMT+0800 (中国标准时间)', '未命名Fri Jan 31 2025 10:24:14 GMT+0800 (中国标准时间)', NULL, '', NULL, '未命名Fri Jan 31 2025 10:24:14 GMT+0800 (中国标准时间)', NULL, 'menu', 0, 0, 0, 0, NULL);
INSERT INTO `sys_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `menu_parent_id`, `menu_sort`, `path`, `name`, `redirect`, `component`, `icon`, `title`, `active`, `type`, `isHide`, `isFull`, `isAffix`, `isKeepAlive`, `tag`) VALUES ('0194ba7e-31b8-79ee-9201-fef455d70995', '2025-01-31 11:53:40.025', '2025-01-31 11:54:03.629', NULL, '449bc286-9cc1-11ef-ae8b-4aa14d9c28f0', 1, '/Fri Jan 31 2025 11:53:40 GMT+0800 (中国标准时间)', 'setting:role:add', NULL, '', '', '新增', NULL, 'button', 0, 0, 0, 0, NULL);
INSERT INTO `sys_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `menu_parent_id`, `menu_sort`, `path`, `name`, `redirect`, `component`, `icon`, `title`, `active`, `type`, `isHide`, `isFull`, `isAffix`, `isKeepAlive`, `tag`) VALUES ('0194ba7e-9787-7b7d-82d0-732c98056820', '2025-01-31 11:54:06.088', '2025-01-31 11:54:24.338', NULL, '449bc286-9cc1-11ef-ae8b-4aa14d9c28f0', 1, '/Fri Jan 31 2025 11:54:06 GMT+0800 (中国标准时间)', 'setting:role:del', NULL, '', NULL, '删除', NULL, 'button', 0, 0, 0, 0, NULL);
INSERT INTO `sys_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `menu_parent_id`, `menu_sort`, `path`, `name`, `redirect`, `component`, `icon`, `title`, `active`, `type`, `isHide`, `isFull`, `isAffix`, `isKeepAlive`, `tag`) VALUES ('0194ba7f-b65a-7df2-8cdf-bfcc4401c035', '2025-01-31 11:55:19.515', '2025-01-31 11:55:45.875', NULL, '449bc286-9cc1-11ef-ae8b-4aa14d9c28f0', 1, '/Fri Jan 31 2025 11:55:19 GMT+0800 (中国标准时间)', 'setting:role:del:batch', NULL, '', '', '批量删除', NULL, 'button', 0, 0, 0, 0, NULL);
INSERT INTO `sys_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `menu_parent_id`, `menu_sort`, `path`, `name`, `redirect`, `component`, `icon`, `title`, `active`, `type`, `isHide`, `isFull`, `isAffix`, `isKeepAlive`, `tag`) VALUES ('0194ba87-1829-79d3-8ef9-9bdb698ddc63', '2025-01-31 12:03:23.306', '2025-01-31 12:03:40.947', NULL, '449bc286-9cc1-11ef-ae8b-4aa14d9c28f0', 1, '/Fri Jan 31 2025 12:03:23 GMT+0800 (中国标准时间)', 'setting:role:permission', NULL, '', '', '权限设置', NULL, 'button', 0, 0, 0, 0, NULL);
INSERT INTO `sys_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `menu_parent_id`, `menu_sort`, `path`, `name`, `redirect`, `component`, `icon`, `title`, `active`, `type`, `isHide`, `isFull`, `isAffix`, `isKeepAlive`, `tag`) VALUES ('0194ba87-b24c-7d9c-8285-7c08e3aee75f', '2025-01-31 12:04:02.765', '2025-01-31 12:04:17.587', NULL, '449bc286-9cc1-11ef-ae8b-4aa14d9c28f0', 1, '/Fri Jan 31 2025 12:04:02 GMT+0800 (中国标准时间)', 'setting:role:info', NULL, '', NULL, '查看详情', NULL, 'button', 0, 0, 0, 0, NULL);
INSERT INTO `sys_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `menu_parent_id`, `menu_sort`, `path`, `name`, `redirect`, `component`, `icon`, `title`, `active`, `type`, `isHide`, `isFull`, `isAffix`, `isKeepAlive`, `tag`) VALUES ('0194bafb-f847-75f3-a055-20f3d1fac851', '2025-01-31 14:11:02.856', '2025-01-31 14:11:19.794', NULL, '449bdcee-9cc1-11ef-ae8b-4aa14d9c28f0', 1, '/Fri Jan 31 2025 14:11:02 GMT+0800 (中国标准时间)', 'setting:api:sync', NULL, '', '', '同步接口', NULL, 'button', 0, 0, 0, 0, NULL);
INSERT INTO `sys_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `menu_parent_id`, `menu_sort`, `path`, `name`, `redirect`, `component`, `icon`, `title`, `active`, `type`, `isHide`, `isFull`, `isAffix`, `isKeepAlive`, `tag`) VALUES ('0194bb0d-f3d1-71f7-9719-200d98ec196d', '2025-01-31 14:30:41.362', '2025-01-31 14:31:03.901', NULL, '3dd8c086-f4f6-4d96-8dab-ce90aff35457', 0, '/Fri Jan 31 2025 14:30:41 GMT+0800 (中国标准时间)', 'setting:user:add', NULL, '', NULL, '新增', NULL, 'button', 0, 0, 0, 0, NULL);
INSERT INTO `sys_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `menu_parent_id`, `menu_sort`, `path`, `name`, `redirect`, `component`, `icon`, `title`, `active`, `type`, `isHide`, `isFull`, `isAffix`, `isKeepAlive`, `tag`) VALUES ('0194bb0f-0907-7065-be18-4feb1227a029', '2025-01-31 14:31:52.327', '2025-01-31 14:32:04.313', NULL, '3dd8c086-f4f6-4d96-8dab-ce90aff35457', 1, '/Fri Jan 31 2025 14:31:52 GMT+0800 (中国标准时间)', 'setting:user:del', NULL, '', NULL, '删除', NULL, 'button', 0, 0, 0, 0, NULL);
INSERT INTO `sys_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `menu_parent_id`, `menu_sort`, `path`, `name`, `redirect`, `component`, `icon`, `title`, `active`, `type`, `isHide`, `isFull`, `isAffix`, `isKeepAlive`, `tag`) VALUES ('0194bb0f-9a8a-7e67-bae3-5fbdeee6cd4e', '2025-01-31 14:32:29.579', '2025-01-31 14:32:41.747', NULL, '3dd8c086-f4f6-4d96-8dab-ce90aff35457', 1, '/Fri Jan 31 2025 14:32:29 GMT+0800 (中国标准时间)', 'setting:user:del:batch', NULL, '', '', '批量删除', NULL, 'button', 0, 0, 0, 0, NULL);
INSERT INTO `sys_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `menu_parent_id`, `menu_sort`, `path`, `name`, `redirect`, `component`, `icon`, `title`, `active`, `type`, `isHide`, `isFull`, `isAffix`, `isKeepAlive`, `tag`) VALUES ('0194bb10-3e92-7cf8-aa6c-a7d1b45cf927', '2025-01-31 14:33:11.571', '2025-01-31 14:33:40.574', NULL, '3dd8c086-f4f6-4d96-8dab-ce90aff35457', 1, '/Fri Jan 31 2025 14:33:11 GMT+0800 (中国标准时间)', 'setting:user:info', NULL, '', '', '查看详情', NULL, 'button', 0, 0, 0, 0, NULL);
INSERT INTO `sys_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `menu_parent_id`, `menu_sort`, `path`, `name`, `redirect`, `component`, `icon`, `title`, `active`, `type`, `isHide`, `isFull`, `isAffix`, `isKeepAlive`, `tag`) VALUES ('0194bb10-e2a6-7157-895c-a0a9334ee7b4', '2025-01-31 14:33:53.574', '2025-01-31 14:34:02.342', NULL, '3dd8c086-f4f6-4d96-8dab-ce90aff35457', 0, '/Fri Jan 31 2025 14:33:53 GMT+0800 (中国标准时间)', 'setting:user:edit', NULL, '', NULL, '编辑', NULL, 'button', 0, 0, 0, 0, NULL);
INSERT INTO `sys_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `menu_parent_id`, `menu_sort`, `path`, `name`, `redirect`, `component`, `icon`, `title`, `active`, `type`, `isHide`, `isFull`, `isAffix`, `isKeepAlive`, `tag`) VALUES ('0194bb11-46ec-7334-b1d7-dbff10fd38cf', '2025-01-31 14:34:19.245', '2025-01-31 14:34:34.716', NULL, '449bc286-9cc1-11ef-ae8b-4aa14d9c28f0', 1, '/Fri Jan 31 2025 14:34:19 GMT+0800 (中国标准时间)', 'setting:role:edit', NULL, '', '', '编辑', NULL, 'button', 0, 0, 0, 0, NULL);
INSERT INTO `sys_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `menu_parent_id`, `menu_sort`, `path`, `name`, `redirect`, `component`, `icon`, `title`, `active`, `type`, `isHide`, `isFull`, `isAffix`, `isKeepAlive`, `tag`) VALUES ('0194bb12-798a-7ea6-95cb-3313909e3f7d', '2025-01-31 14:35:37.739', '2025-01-31 14:36:21.165', NULL, '3dd8c086-f4f6-4d96-8dab-ce90aff35457', 1, '/Fri Jan 31 2025 14:35:37 GMT+0800 (中国标准时间)', 'setting:user:reset:password', NULL, '', '', '重置密码', NULL, 'button', 0, 0, 0, 0, NULL);
INSERT INTO `sys_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `menu_parent_id`, `menu_sort`, `path`, `name`, `redirect`, `component`, `icon`, `title`, `active`, `type`, `isHide`, `isFull`, `isAffix`, `isKeepAlive`, `tag`) VALUES ('0194bb14-4341-7d98-8ed0-ef671abb8d3a', '2025-01-31 14:37:34.914', '2025-01-31 14:38:14.070', NULL, '3dd8c086-f4f6-4d96-8dab-ce90aff35457', 1, '/Fri Jan 31 2025 14:37:34 GMT+0800 (中国标准时间)', 'setting:user:reset:password:batch', NULL, '', NULL, '批量重置密码', NULL, 'button', 0, 0, 0, 0, NULL);
INSERT INTO `sys_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `menu_parent_id`, `menu_sort`, `path`, `name`, `redirect`, `component`, `icon`, `title`, `active`, `type`, `isHide`, `isFull`, `isAffix`, `isKeepAlive`, `tag`) VALUES ('0194bb19-050b-7f1f-a2cb-3eab5225d206', '2025-01-31 14:42:46.668', '2025-01-31 14:43:08.619', NULL, '449bd3a2-9cc1-11ef-ae8b-4aa14d9c28f0', 1, '/Fri Jan 31 2025 14:42:46 GMT+0800 (中国标准时间)', 'setting:menu:add', NULL, '', '', '新增', NULL, 'button', 0, 0, 0, 0, NULL);
INSERT INTO `sys_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `menu_parent_id`, `menu_sort`, `path`, `name`, `redirect`, `component`, `icon`, `title`, `active`, `type`, `isHide`, `isFull`, `isAffix`, `isKeepAlive`, `tag`) VALUES ('0194bb19-cf5f-7a0e-8dba-261c5a0ea5b9', '2025-01-31 14:43:38.464', '2025-01-31 14:43:56.875', NULL, '449bd3a2-9cc1-11ef-ae8b-4aa14d9c28f0', 1, '/Fri Jan 31 2025 14:43:38 GMT+0800 (中国标准时间)', 'setting:menu:del:batch', NULL, '', '', '批量删除', NULL, 'button', 0, 0, 0, 0, NULL);
INSERT INTO `sys_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `menu_parent_id`, `menu_sort`, `path`, `name`, `redirect`, `component`, `icon`, `title`, `active`, `type`, `isHide`, `isFull`, `isAffix`, `isKeepAlive`, `tag`) VALUES ('0194bf93-9754-7d3a-bbb7-ab2f0a2446e0', '2025-02-01 11:35:08.373', '2025-02-01 11:38:35.247', '2025-02-08 15:09:13.764', '', 1, '/vba', 'vba', '', '', 'el-icon-takeaway-box', '组件', '', 'menu', 0, 0, 0, 0, '');
INSERT INTO `sys_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `menu_parent_id`, `menu_sort`, `path`, `name`, `redirect`, `component`, `icon`, `title`, `active`, `type`, `isHide`, `isFull`, `isAffix`, `isKeepAlive`, `tag`) VALUES ('0194bf94-68b8-7835-ad14-53b77a16c49b', '2025-02-01 11:36:01.977', '2025-02-01 15:57:39.063', NULL, '0194bf93-9754-7d3a-bbb7-ab2f0a2446e0', 0, '/vab/mini', 'minivab', '', 'vab/mini', 'el-icon-magic-stick', '原子组件', '', 'menu', 0, 0, 0, 0, '');
INSERT INTO `sys_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `menu_parent_id`, `menu_sort`, `path`, `name`, `redirect`, `component`, `icon`, `title`, `active`, `type`, `isHide`, `isFull`, `isAffix`, `isKeepAlive`, `tag`) VALUES ('0194bf9c-b1f1-7140-808d-699c361930f9', '2025-02-01 11:45:05.009', '2025-02-01 11:46:04.847', NULL, '0194bf93-9754-7d3a-bbb7-ab2f0a2446e0', 1, '/vab/iconfont', 'iconfont', NULL, 'vab/iconfont', 'el-icon-orange', '扩展图标', NULL, 'menu', 0, 0, 0, 0, NULL);
INSERT INTO `sys_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `menu_parent_id`, `menu_sort`, `path`, `name`, `redirect`, `component`, `icon`, `title`, `active`, `type`, `isHide`, `isFull`, `isAffix`, `isKeepAlive`, `tag`) VALUES ('0194bf9e-4604-7d1f-a76b-3b96a731220a', '2025-02-01 11:46:48.453', '2025-02-01 11:47:44.946', NULL, '0194bf93-9754-7d3a-bbb7-ab2f0a2446e0', 2, '/vab/data', 'vabdata', NULL, '', 'el-icon-histogram', 'Data 数据展示', NULL, 'menu', 0, 0, 0, 0, NULL);
INSERT INTO `sys_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `menu_parent_id`, `menu_sort`, `path`, `name`, `redirect`, `component`, `icon`, `title`, `active`, `type`, `isHide`, `isFull`, `isAffix`, `isKeepAlive`, `tag`) VALUES ('0194bf9f-4a87-762e-9d44-cfd23a8af030', '2025-02-01 11:47:55.144', '2025-02-01 11:51:11.687', NULL, '0194bf9e-4604-7d1f-a76b-3b96a731220a', 0, '/vab/chart', 'chart', '', 'vab/chart', '', '图表 Echarts', '', 'menu', 0, 0, 0, 0, '');
INSERT INTO `sys_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `menu_parent_id`, `menu_sort`, `path`, `name`, `redirect`, `component`, `icon`, `title`, `active`, `type`, `isHide`, `isFull`, `isAffix`, `isKeepAlive`, `tag`) VALUES ('0194bfa0-1665-7d90-adf4-08404115451d', '2025-02-01 11:48:47.334', '2025-02-01 11:51:16.335', NULL, '0194bf9e-4604-7d1f-a76b-3b96a731220a', 1, '/vab/statistic', 'statistic', '', 'vab/statistic', '', '统计数值', '', 'menu', 0, 0, 0, 0, '');
INSERT INTO `sys_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `menu_parent_id`, `menu_sort`, `path`, `name`, `redirect`, `component`, `icon`, `title`, `active`, `type`, `isHide`, `isFull`, `isAffix`, `isKeepAlive`, `tag`) VALUES ('0194c05e-a16e-7173-8dcb-46b20aa43071', '2025-02-01 15:16:54.767', '2025-02-01 15:17:31.917', NULL, '0194bf9e-4604-7d1f-a76b-3b96a731220a', 2, '/vab/video', 'scvideo', NULL, 'vab/video', '', '视频播放器', NULL, 'menu', 0, 0, 0, 0, NULL);
INSERT INTO `sys_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `menu_parent_id`, `menu_sort`, `path`, `name`, `redirect`, `component`, `icon`, `title`, `active`, `type`, `isHide`, `isFull`, `isAffix`, `isKeepAlive`, `tag`) VALUES ('0194c05f-3b43-7d17-8ff9-55ff9b6ebc06', '2025-02-01 15:17:34.148', '2025-02-01 15:18:02.440', NULL, '0194bf9e-4604-7d1f-a76b-3b96a731220a', 3, '/vab/qrcode', 'qrcode', NULL, 'vab/qrcode', NULL, '二维码', NULL, 'menu', 0, 0, 0, 0, NULL);
INSERT INTO `sys_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `menu_parent_id`, `menu_sort`, `path`, `name`, `redirect`, `component`, `icon`, `title`, `active`, `type`, `isHide`, `isFull`, `isAffix`, `isKeepAlive`, `tag`) VALUES ('0194c060-960b-7177-b13a-3ed45b7f043c', '2025-02-01 15:19:02.924', '2025-02-01 15:19:43.880', NULL, '0194bf93-9754-7d3a-bbb7-ab2f0a2446e0', 3, '/vab/form', 'vabform', NULL, '', 'el-icon-edit-pen', 'Form 数据录入', NULL, 'menu', 0, 0, 0, 0, NULL);
INSERT INTO `sys_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `menu_parent_id`, `menu_sort`, `path`, `name`, `redirect`, `component`, `icon`, `title`, `active`, `type`, `isHide`, `isFull`, `isAffix`, `isKeepAlive`, `tag`) VALUES ('0194c061-437e-7b52-b196-b93acf58c6cf', '2025-02-01 15:19:47.327', '2025-02-01 15:20:13.014', NULL, '0194c060-960b-7177-b13a-3ed45b7f043c', 0, '/vab/tableselect', 'tableselect', NULL, 'vab/tableselect', '', '表格选择器', NULL, 'menu', 0, 0, 0, 0, NULL);
INSERT INTO `sys_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `menu_parent_id`, `menu_sort`, `path`, `name`, `redirect`, `component`, `icon`, `title`, `active`, `type`, `isHide`, `isFull`, `isAffix`, `isKeepAlive`, `tag`) VALUES ('0194c061-bcde-791f-b8d4-2515c70d43d6', '2025-02-01 15:20:18.399', '2025-02-01 15:20:51.365', NULL, '0194c060-960b-7177-b13a-3ed45b7f043c', 1, '/vab/formtable', 'formtable', NULL, 'vab/formtable', '', '表单表格', NULL, 'menu', 0, 0, 0, 0, NULL);
INSERT INTO `sys_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `menu_parent_id`, `menu_sort`, `path`, `name`, `redirect`, `component`, `icon`, `title`, `active`, `type`, `isHide`, `isFull`, `isAffix`, `isKeepAlive`, `tag`) VALUES ('0194c062-6042-7a77-9a5a-a4941efc857d', '2025-02-01 15:21:00.227', '2025-02-01 15:21:20.291', NULL, '0194c060-960b-7177-b13a-3ed45b7f043c', 2, '/vab/selectFilter', 'selectFilter', NULL, 'vab/selectFilter', '', '分类筛选器', NULL, 'menu', 0, 0, 0, 0, NULL);
INSERT INTO `sys_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `menu_parent_id`, `menu_sort`, `path`, `name`, `redirect`, `component`, `icon`, `title`, `active`, `type`, `isHide`, `isFull`, `isAffix`, `isKeepAlive`, `tag`) VALUES ('0194c062-c29e-718e-9e78-a5a627057372', '2025-02-01 15:21:25.406', '2025-02-01 15:21:54.169', NULL, '0194c060-960b-7177-b13a-3ed45b7f043c', 3, '/vab/filterbar', 'filterBar', NULL, 'vab/filterbar', '', '过滤器v2', NULL, 'menu', 0, 0, 0, 0, NULL);
INSERT INTO `sys_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `menu_parent_id`, `menu_sort`, `path`, `name`, `redirect`, `component`, `icon`, `title`, `active`, `type`, `isHide`, `isFull`, `isAffix`, `isKeepAlive`, `tag`) VALUES ('0194c063-48bc-73d8-8712-7cb0aa031a36', '2025-02-01 15:21:59.740', '2025-02-01 15:22:22.108', NULL, '0194c060-960b-7177-b13a-3ed45b7f043c', 4, '/vab/upload', 'upload', NULL, 'vab/upload', '', '上传', NULL, 'menu', 0, 0, 0, 0, NULL);
INSERT INTO `sys_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `menu_parent_id`, `menu_sort`, `path`, `name`, `redirect`, `component`, `icon`, `title`, `active`, `type`, `isHide`, `isFull`, `isAffix`, `isKeepAlive`, `tag`) VALUES ('0194c063-dc53-7bbb-a779-f9a13ac0e9f7', '2025-02-01 15:22:37.524', '2025-02-01 15:22:54.311', NULL, '0194c060-960b-7177-b13a-3ed45b7f043c', 5, '/vab/select', 'scselect', NULL, 'vab/select', '', '异步选择器', NULL, 'menu', 0, 0, 0, 0, NULL);
INSERT INTO `sys_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `menu_parent_id`, `menu_sort`, `path`, `name`, `redirect`, `component`, `icon`, `title`, `active`, `type`, `isHide`, `isFull`, `isAffix`, `isKeepAlive`, `tag`) VALUES ('0194c064-4c7b-7a87-9ee6-34352d390e05', '2025-02-01 15:23:06.236', '2025-02-01 15:23:22.918', NULL, '0194c060-960b-7177-b13a-3ed45b7f043c', 6, '/vab/iconselect', 'iconSelect', NULL, 'vab/iconselect', '', '图标选择器', NULL, 'menu', 0, 0, 0, 0, NULL);
INSERT INTO `sys_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `menu_parent_id`, `menu_sort`, `path`, `name`, `redirect`, `component`, `icon`, `title`, `active`, `type`, `isHide`, `isFull`, `isAffix`, `isKeepAlive`, `tag`) VALUES ('0194c064-b2e3-71b9-82f5-8b8034be1637', '2025-02-01 15:23:32.451', '2025-02-01 15:23:48.407', NULL, '0194c060-960b-7177-b13a-3ed45b7f043c', 7, '/vab/cron', 'cron', NULL, 'vab/cron', '', 'Cron规则生成器', NULL, 'menu', 0, 0, 0, 0, NULL);
INSERT INTO `sys_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `menu_parent_id`, `menu_sort`, `path`, `name`, `redirect`, `component`, `icon`, `title`, `active`, `type`, `isHide`, `isFull`, `isAffix`, `isKeepAlive`, `tag`) VALUES ('0194c065-19c1-7c9e-acc7-4696518054e2', '2025-02-01 15:23:58.786', '2025-02-01 15:24:14.968', NULL, '0194c060-960b-7177-b13a-3ed45b7f043c', 8, '/vab/editor', 'editor', NULL, 'vab/editor', '', '富文本编辑器', NULL, 'menu', 0, 0, 0, 0, NULL);
INSERT INTO `sys_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `menu_parent_id`, `menu_sort`, `path`, `name`, `redirect`, `component`, `icon`, `title`, `active`, `type`, `isHide`, `isFull`, `isAffix`, `isKeepAlive`, `tag`) VALUES ('0194c065-7fc5-77fa-a172-196ec35ab43e', '2025-02-01 15:24:24.902', '2025-02-01 15:24:38.969', NULL, '0194c060-960b-7177-b13a-3ed45b7f043c', 9, '/vab/codeeditor', 'codeeditor', NULL, 'vab/codeeditor', '', '代码编辑器', NULL, 'menu', 0, 0, 0, 0, NULL);
INSERT INTO `sys_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `menu_parent_id`, `menu_sort`, `path`, `name`, `redirect`, `component`, `icon`, `title`, `active`, `type`, `isHide`, `isFull`, `isAffix`, `isKeepAlive`, `tag`) VALUES ('0194c067-4397-7c7b-bccb-0178fe27724b', '2025-02-01 15:26:20.568', '2025-02-01 15:26:45.187', NULL, '0194bf93-9754-7d3a-bbb7-ab2f0a2446e0', 4, '/vab/feedback', 'vabfeedback', NULL, '', 'el-icon-mouse', 'Feedback 反馈', NULL, 'menu', 0, 0, 0, 0, NULL);
INSERT INTO `sys_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `menu_parent_id`, `menu_sort`, `path`, `name`, `redirect`, `component`, `icon`, `title`, `active`, `type`, `isHide`, `isFull`, `isAffix`, `isKeepAlive`, `tag`) VALUES ('0194c067-ae8a-72ea-a01b-bdd7e7d408b0', '2025-02-01 15:26:47.946', '2025-02-01 15:27:11.744', NULL, '0194c067-4397-7c7b-bccb-0178fe27724b', 0, '/vab/drag', 'drag', NULL, 'vab/drag', '', '拖拽排序', NULL, 'menu', 0, 0, 0, 0, NULL);
INSERT INTO `sys_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `menu_parent_id`, `menu_sort`, `path`, `name`, `redirect`, `component`, `icon`, `title`, `active`, `type`, `isHide`, `isFull`, `isAffix`, `isKeepAlive`, `tag`) VALUES ('0194c068-2c83-7e40-90c9-7fe30ac4849f', '2025-02-01 15:27:20.196', '2025-02-01 15:27:39.547', NULL, '0194c067-4397-7c7b-bccb-0178fe27724b', 1, '/vab/contextmenu', 'contextmenu', NULL, 'vab/contextmenu', '', '右键菜单', NULL, 'menu', 0, 0, 0, 0, NULL);
INSERT INTO `sys_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `menu_parent_id`, `menu_sort`, `path`, `name`, `redirect`, `component`, `icon`, `title`, `active`, `type`, `isHide`, `isFull`, `isAffix`, `isKeepAlive`, `tag`) VALUES ('0194c068-7ff8-7c8a-871b-954a7c4f80c7', '2025-02-01 15:27:41.561', '2025-02-01 15:28:02.086', NULL, '0194c067-4397-7c7b-bccb-0178fe27724b', 2, '/vab/cropper', 'cropper', NULL, 'vab/cropper', '', '图像剪裁', NULL, 'menu', 0, 0, 0, 0, NULL);
INSERT INTO `sys_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `menu_parent_id`, `menu_sort`, `path`, `name`, `redirect`, `component`, `icon`, `title`, `active`, `type`, `isHide`, `isFull`, `isAffix`, `isKeepAlive`, `tag`) VALUES ('0194c068-dd37-77a5-add6-891a4b39e105', '2025-02-01 15:28:05.432', '2025-02-01 15:28:31.963', NULL, '0194c067-4397-7c7b-bccb-0178fe27724b', 3, '/vab/fileselect', 'fileselect', NULL, 'vab/fileselect', '', '资源库选择器', NULL, 'menu', 0, 0, 0, 0, NULL);
INSERT INTO `sys_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `menu_parent_id`, `menu_sort`, `path`, `name`, `redirect`, `component`, `icon`, `title`, `active`, `type`, `isHide`, `isFull`, `isAffix`, `isKeepAlive`, `tag`) VALUES ('0194c069-74f1-70bf-be63-1420e2186e1c', '2025-02-01 15:28:44.273', '2025-02-01 15:29:01.932', NULL, '0194c067-4397-7c7b-bccb-0178fe27724b', 4, '/vab/dialog', 'dialogExtend', NULL, 'vab/dialog', '', '弹窗扩展', NULL, 'menu', 0, 0, 0, 0, NULL);
INSERT INTO `sys_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `menu_parent_id`, `menu_sort`, `path`, `name`, `redirect`, `component`, `icon`, `title`, `active`, `type`, `isHide`, `isFull`, `isAffix`, `isKeepAlive`, `tag`) VALUES ('0194c06a-08fd-7631-9bd6-5492f4790a46', '2025-02-01 15:29:22.174', '2025-02-01 15:29:54.333', NULL, '0194bf93-9754-7d3a-bbb7-ab2f0a2446e0', 5, '/vab/others', 'vabothers', NULL, '', 'el-icon-more-filled', 'Others 其他', NULL, 'menu', 0, 0, 0, 0, NULL);
INSERT INTO `sys_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `menu_parent_id`, `menu_sort`, `path`, `name`, `redirect`, `component`, `icon`, `title`, `active`, `type`, `isHide`, `isFull`, `isAffix`, `isKeepAlive`, `tag`) VALUES ('0194c06a-b2e3-7e8e-9a6d-c51f171c46a9', '2025-02-01 15:30:05.668', '2025-02-01 15:30:21.941', NULL, '0194c06a-08fd-7631-9bd6-5492f4790a46', 0, '/vab/print', 'print', NULL, 'vab/print', '', '打印', NULL, 'menu', 0, 0, 0, 0, NULL);
INSERT INTO `sys_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `menu_parent_id`, `menu_sort`, `path`, `name`, `redirect`, `component`, `icon`, `title`, `active`, `type`, `isHide`, `isFull`, `isAffix`, `isKeepAlive`, `tag`) VALUES ('0194c06b-2618-7664-a45a-ff3a24683d13', '2025-02-01 15:30:35.161', '2025-02-01 15:30:49.907', NULL, '0194c06a-08fd-7631-9bd6-5492f4790a46', 1, '/vab/watermark', 'watermark', NULL, 'vab/watermark', '', '水印', NULL, 'menu', 0, 0, 0, 0, NULL);
INSERT INTO `sys_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `menu_parent_id`, `menu_sort`, `path`, `name`, `redirect`, `component`, `icon`, `title`, `active`, `type`, `isHide`, `isFull`, `isAffix`, `isKeepAlive`, `tag`) VALUES ('0194c06b-816c-7d84-98f9-6284c821a690', '2025-02-01 15:30:58.541', '2025-02-01 15:31:13.580', NULL, '0194c06a-08fd-7631-9bd6-5492f4790a46', 2, '/vab/importexport', 'importexport', NULL, 'vab/importexport', '', '文件导出导入', NULL, 'menu', 0, 0, 0, 0, NULL);
INSERT INTO `sys_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `menu_parent_id`, `menu_sort`, `path`, `name`, `redirect`, `component`, `icon`, `title`, `active`, `type`, `isHide`, `isFull`, `isAffix`, `isKeepAlive`, `tag`) VALUES ('0194c06c-1f3c-7870-912c-3541586d4d54', '2025-02-01 15:31:38.941', '2025-02-01 15:32:20.690', NULL, '0194bf93-9754-7d3a-bbb7-ab2f0a2446e0', 6, 'vab/list', 'list', NULL, '', 'el-icon-fold', 'Table 数据列表', NULL, 'menu', 0, 0, 0, 0, NULL);
INSERT INTO `sys_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `menu_parent_id`, `menu_sort`, `path`, `name`, `redirect`, `component`, `icon`, `title`, `active`, `type`, `isHide`, `isFull`, `isAffix`, `isKeepAlive`, `tag`) VALUES ('0194c06c-cc98-705d-afb7-61bbb405edd2', '2025-02-01 15:32:23.320', '2025-02-01 15:32:43.228', NULL, '0194c06c-1f3c-7870-912c-3541586d4d54', 0, '/vab/table/base', 'tableBase', NULL, 'vab/table/base', '', '基础数据列表', NULL, 'menu', 0, 0, 0, 0, NULL);
INSERT INTO `sys_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `menu_parent_id`, `menu_sort`, `path`, `name`, `redirect`, `component`, `icon`, `title`, `active`, `type`, `isHide`, `isFull`, `isAffix`, `isKeepAlive`, `tag`) VALUES ('0194c06d-22fe-74f1-99d2-a30d428db8b5', '2025-02-01 15:32:45.439', '2025-02-01 15:33:04.159', NULL, '0194c06c-1f3c-7870-912c-3541586d4d54', 1, '/vab/table/thead', 'tableThead', NULL, 'vab/table/thead', '', '多级表头', NULL, 'menu', 0, 0, 0, 0, NULL);
INSERT INTO `sys_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `menu_parent_id`, `menu_sort`, `path`, `name`, `redirect`, `component`, `icon`, `title`, `active`, `type`, `isHide`, `isFull`, `isAffix`, `isKeepAlive`, `tag`) VALUES ('0194c06d-7205-79c4-9e33-5a9b0e0f7b4e', '2025-02-01 15:33:05.670', '2025-02-01 15:33:26.520', NULL, '0194c06c-1f3c-7870-912c-3541586d4d54', 2, '/vab/table/column', 'tableCustomColumn', NULL, 'vab/table/column', '', '动态列', NULL, 'menu', 0, 0, 0, 0, NULL);
INSERT INTO `sys_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `menu_parent_id`, `menu_sort`, `path`, `name`, `redirect`, `component`, `icon`, `title`, `active`, `type`, `isHide`, `isFull`, `isAffix`, `isKeepAlive`, `tag`) VALUES ('0194c06d-c9f9-7ac9-a99a-1f48ef8e3894', '2025-02-01 15:33:28.186', '2025-02-01 15:33:48.545', NULL, '0194c06c-1f3c-7870-912c-3541586d4d54', 3, '/vab/table/remote', 'tableRemote', NULL, 'vab/table/remote', '', '远程排序过滤', NULL, 'menu', 0, 0, 0, 0, NULL);
INSERT INTO `sys_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `menu_parent_id`, `menu_sort`, `path`, `name`, `redirect`, `component`, `icon`, `title`, `active`, `type`, `isHide`, `isFull`, `isAffix`, `isKeepAlive`, `tag`) VALUES ('0194c06e-6300-7693-852c-acbf5cd0ca5c', '2025-02-01 15:34:07.361', '2025-02-01 15:34:34.954', NULL, '0194bf93-9754-7d3a-bbb7-ab2f0a2446e0', 7, '/vab/workflow', 'workflow', NULL, 'vab/workflow', 'el-icon-share', '工作流设计器', NULL, 'menu', 0, 0, 0, 0, NULL);
INSERT INTO `sys_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `menu_parent_id`, `menu_sort`, `path`, `name`, `redirect`, `component`, `icon`, `title`, `active`, `type`, `isHide`, `isFull`, `isAffix`, `isKeepAlive`, `tag`) VALUES ('0194c06f-0495-7426-917f-7cb44cc44384', '2025-02-01 15:34:48.726', '2025-02-01 15:35:24.172', NULL, '0194bf93-9754-7d3a-bbb7-ab2f0a2446e0', 8, '/vab/formrender', 'formRender', NULL, 'vab/form', 'el-icon-message-box', '动态表单', NULL, 'menu', 0, 0, 0, 0, NULL);
INSERT INTO `sys_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `menu_parent_id`, `menu_sort`, `path`, `name`, `redirect`, `component`, `icon`, `title`, `active`, `type`, `isHide`, `isFull`, `isAffix`, `isKeepAlive`, `tag`) VALUES ('0194c06f-ecfe-7046-aa5d-28663ff5da2e', '2025-02-01 15:35:48.222', '2025-02-01 15:36:39.841', '2025-02-08 15:09:13.764', '', 2, '/template', 'template', '', '', 'el-icon-files', '模板', '', 'menu', 0, 0, 0, 0, '');
INSERT INTO `sys_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `menu_parent_id`, `menu_sort`, `path`, `name`, `redirect`, `component`, `icon`, `title`, `active`, `type`, `isHide`, `isFull`, `isAffix`, `isKeepAlive`, `tag`) VALUES ('0194c070-c1ea-74f1-ad63-14fbb08c2f7b', '2025-02-01 15:36:42.731', '2025-02-01 15:37:10.810', NULL, '0194c06f-ecfe-7046-aa5d-28663ff5da2e', 0, '/template/layout', 'layoutTemplate', NULL, '', 'el-icon-grid', '布局', NULL, 'menu', 0, 0, 0, 0, NULL);
INSERT INTO `sys_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `menu_parent_id`, `menu_sort`, `path`, `name`, `redirect`, `component`, `icon`, `title`, `active`, `type`, `isHide`, `isFull`, `isAffix`, `isKeepAlive`, `tag`) VALUES ('0194c071-4ead-7655-8723-765ce35e5aee', '2025-02-01 15:37:18.766', '2025-02-01 15:37:42.750', NULL, '0194c070-c1ea-74f1-ad63-14fbb08c2f7b', 0, '/template/layout/blank', 'blank', NULL, 'template/layout/blank', '', '空白模板', NULL, 'menu', 0, 0, 0, 0, NULL);
INSERT INTO `sys_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `menu_parent_id`, `menu_sort`, `path`, `name`, `redirect`, `component`, `icon`, `title`, `active`, `type`, `isHide`, `isFull`, `isAffix`, `isKeepAlive`, `tag`) VALUES ('0194c071-ccd4-7b10-a4ef-5bf56fda22f4', '2025-02-01 15:37:51.061', '2025-02-01 15:38:14.271', NULL, '0194c070-c1ea-74f1-ad63-14fbb08c2f7b', 1, '/template/layout/layoutTCB', 'layoutTCB', NULL, 'template/layout/layoutTCB', '', '上中下布局', NULL, 'menu', 0, 0, 0, 0, NULL);
INSERT INTO `sys_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `menu_parent_id`, `menu_sort`, `path`, `name`, `redirect`, `component`, `icon`, `title`, `active`, `type`, `isHide`, `isFull`, `isAffix`, `isKeepAlive`, `tag`) VALUES ('0194c072-4794-7586-9fce-cff2783f9ee5', '2025-02-01 15:38:22.485', '2025-02-01 15:38:36.381', NULL, '0194c070-c1ea-74f1-ad63-14fbb08c2f7b', 2, '/template/layout/layoutLCR', 'layoutLCR', NULL, 'template/layout/layoutLCR', '', '左中右布局', NULL, 'menu', 0, 0, 0, 0, NULL);
INSERT INTO `sys_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `menu_parent_id`, `menu_sort`, `path`, `name`, `redirect`, `component`, `icon`, `title`, `active`, `type`, `isHide`, `isFull`, `isAffix`, `isKeepAlive`, `tag`) VALUES ('0194c072-a7e1-71b9-ab2d-5196dfccadc0', '2025-02-01 15:38:47.137', '2025-02-01 15:40:10.487', NULL, '0194c06f-ecfe-7046-aa5d-28663ff5da2e', 1, '/template/list', 'list', NULL, '', 'el-icon-document', '列表', NULL, 'menu', 0, 0, 0, 0, NULL);
INSERT INTO `sys_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `menu_parent_id`, `menu_sort`, `path`, `name`, `redirect`, `component`, `icon`, `title`, `active`, `type`, `isHide`, `isFull`, `isAffix`, `isKeepAlive`, `tag`) VALUES ('0194c074-1a05-733c-814e-0a21e5bd1a94', '2025-02-01 15:40:21.893', '2025-02-01 15:40:39.660', NULL, '0194c072-a7e1-71b9-ab2d-5196dfccadc0', 0, '/template/list/crud', 'listCrud', NULL, 'template/list/crud', '', 'CRUD', NULL, 'menu', 0, 0, 0, 0, NULL);
INSERT INTO `sys_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `menu_parent_id`, `menu_sort`, `path`, `name`, `redirect`, `component`, `icon`, `title`, `active`, `type`, `isHide`, `isFull`, `isAffix`, `isKeepAlive`, `tag`) VALUES ('0194c074-675b-703a-8bba-b6a04c305405', '2025-02-01 15:40:41.691', '2025-02-01 15:41:39.010', NULL, '0194c072-a7e1-71b9-ab2d-5196dfccadc0', 1, '/template/list/tree', 'listTree', NULL, 'template/list/tree', '', '左树右表', NULL, 'menu', 0, 0, 0, 0, NULL);
INSERT INTO `sys_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `menu_parent_id`, `menu_sort`, `path`, `name`, `redirect`, `component`, `icon`, `title`, `active`, `type`, `isHide`, `isFull`, `isAffix`, `isKeepAlive`, `tag`) VALUES ('0194c075-6470-7659-8be3-2f0b8a5c5f49', '2025-02-01 15:41:46.481', '2025-02-01 15:42:00.959', NULL, '0194c072-a7e1-71b9-ab2d-5196dfccadc0', 2, '/template/list/tab', 'listTab', NULL, 'template/list/tab', '', '分类表格', NULL, 'menu', 0, 0, 0, 0, NULL);
INSERT INTO `sys_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `menu_parent_id`, `menu_sort`, `path`, `name`, `redirect`, `component`, `icon`, `title`, `active`, `type`, `isHide`, `isFull`, `isAffix`, `isKeepAlive`, `tag`) VALUES ('0194c075-b95b-736e-874f-058e6aa933b1', '2025-02-01 15:42:08.220', '2025-02-01 15:42:21.780', NULL, '0194c072-a7e1-71b9-ab2d-5196dfccadc0', 3, '/template/list/son', 'listSon', NULL, 'template/list/son', '', '子母表', NULL, 'menu', 0, 0, 0, 0, NULL);
INSERT INTO `sys_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `menu_parent_id`, `menu_sort`, `path`, `name`, `redirect`, `component`, `icon`, `title`, `active`, `type`, `isHide`, `isFull`, `isAffix`, `isKeepAlive`, `tag`) VALUES ('0194c076-08e1-7868-af72-df7b25d81204', '2025-02-01 15:42:28.578', '2025-02-01 15:42:50.961', NULL, '0194c072-a7e1-71b9-ab2d-5196dfccadc0', 4, '/template/list/widthlist', 'widthlist', NULL, 'template/list/width', '', '定宽列表', NULL, 'menu', 0, 0, 0, 0, NULL);
INSERT INTO `sys_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `menu_parent_id`, `menu_sort`, `path`, `name`, `redirect`, `component`, `icon`, `title`, `active`, `type`, `isHide`, `isFull`, `isAffix`, `isKeepAlive`, `tag`) VALUES ('0194c077-ea07-76dd-967f-707d0bd376ad', '2025-02-01 15:44:31.752', '2025-02-01 15:44:51.093', NULL, '0194c06f-ecfe-7046-aa5d-28663ff5da2e', 2, '/template/other', 'other', NULL, '', 'el-icon-folder', '其他', NULL, 'menu', 0, 0, 0, 0, NULL);
INSERT INTO `sys_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `menu_parent_id`, `menu_sort`, `path`, `name`, `redirect`, `component`, `icon`, `title`, `active`, `type`, `isHide`, `isFull`, `isAffix`, `isKeepAlive`, `tag`) VALUES ('0194c078-4006-7937-8f09-bf5d542398d3', '2025-02-01 15:44:53.767', '2025-02-01 15:45:15.236', NULL, '0194c077-ea07-76dd-967f-707d0bd376ad', 0, '/template/other/stepform', 'stepform', NULL, 'template/other/stepform', '', '分步表单', NULL, 'menu', 0, 0, 0, 0, NULL);
INSERT INTO `sys_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `menu_parent_id`, `menu_sort`, `path`, `name`, `redirect`, `component`, `icon`, `title`, `active`, `type`, `isHide`, `isFull`, `isAffix`, `isKeepAlive`, `tag`) VALUES ('0194c079-9d8c-7d4e-b342-bac26fd6157d', '2025-02-01 15:46:23.245', '2025-02-01 15:47:05.683', '2025-02-08 15:09:13.764', '', 3, '/other', 'other', NULL, '', 'el-icon-more-filled', '其他', NULL, 'menu', 0, 0, 0, 0, NULL);
INSERT INTO `sys_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `menu_parent_id`, `menu_sort`, `path`, `name`, `redirect`, `component`, `icon`, `title`, `active`, `type`, `isHide`, `isFull`, `isAffix`, `isKeepAlive`, `tag`) VALUES ('0194c07a-5e16-701b-a3b9-6cbce1fffc69', '2025-02-01 15:47:12.534', '2025-02-01 15:47:41.707', NULL, '0194c079-9d8c-7d4e-b342-bac26fd6157d', 0, '/other/directive', 'directive', NULL, 'other/directive', 'el-icon-price-tag', '指令', NULL, 'menu', 0, 0, 0, 0, NULL);
INSERT INTO `sys_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `menu_parent_id`, `menu_sort`, `path`, `name`, `redirect`, `component`, `icon`, `title`, `active`, `type`, `isHide`, `isFull`, `isAffix`, `isKeepAlive`, `tag`) VALUES ('0194c07a-f14a-7ad1-bf90-0712fc157dea', '2025-02-01 15:47:50.219', '2025-02-01 15:48:09.465', NULL, '0194c079-9d8c-7d4e-b342-bac26fd6157d', 1, '/other/viewTags', 'viewTags', NULL, 'other/viewTags', 'el-icon-files', '标签操作', NULL, 'menu', 0, 0, 0, 0, NULL);
INSERT INTO `sys_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `menu_parent_id`, `menu_sort`, `path`, `name`, `redirect`, `component`, `icon`, `title`, `active`, `type`, `isHide`, `isFull`, `isAffix`, `isKeepAlive`, `tag`) VALUES ('0194c07b-761f-7ab2-8abe-a0892d128bb9', '2025-02-01 15:48:24.224', '2025-02-01 15:49:24.512', NULL, '[\"0194c079-9d8c-7d4e-b342-bac26fd6157d\"]', 2, '/other/fullpage', 'fullpage', NULL, 'other/fullpage', 'el-icon-monitor', '整页路由', NULL, 'menu', 0, 1, 0, 0, NULL);
INSERT INTO `sys_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `menu_parent_id`, `menu_sort`, `path`, `name`, `redirect`, `component`, `icon`, `title`, `active`, `type`, `isHide`, `isFull`, `isAffix`, `isKeepAlive`, `tag`) VALUES ('0194c07d-4a12-7157-8442-428181f76f19', '2025-02-01 15:50:24.018', '2025-02-01 15:50:50.866', NULL, '0194c079-9d8c-7d4e-b342-bac26fd6157d', 2, '/other/verificate', 'verificate', NULL, 'other/verificate', 'el-icon-open', '表单验证', NULL, 'menu', 0, 0, 0, 0, NULL);
INSERT INTO `sys_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `menu_parent_id`, `menu_sort`, `path`, `name`, `redirect`, `component`, `icon`, `title`, `active`, `type`, `isHide`, `isFull`, `isAffix`, `isKeepAlive`, `tag`) VALUES ('0194c07d-d45a-7e5f-9a05-d85cd67d96d5', '2025-02-01 15:50:59.419', '2025-02-01 15:51:22.657', NULL, '0194c079-9d8c-7d4e-b342-bac26fd6157d', 3, '/other/loadJS', 'loadJS', NULL, 'other/loadJS', 'el-icon-location-information', '异步加载JS', NULL, 'menu', 0, 0, 0, 0, NULL);
INSERT INTO `sys_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `menu_parent_id`, `menu_sort`, `path`, `name`, `redirect`, `component`, `icon`, `title`, `active`, `type`, `isHide`, `isFull`, `isAffix`, `isKeepAlive`, `tag`) VALUES ('0194c07e-4e3d-7441-a7dd-47e225bf0d4b', '2025-02-01 15:51:30.621', '2025-02-01 15:51:50.458', NULL, '0194c079-9d8c-7d4e-b342-bac26fd6157d', 4, '/link', 'link', NULL, '', 'el-icon-link', '外部链接', NULL, 'menu', 0, 0, 0, 0, NULL);
INSERT INTO `sys_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `menu_parent_id`, `menu_sort`, `path`, `name`, `redirect`, `component`, `icon`, `title`, `active`, `type`, `isHide`, `isFull`, `isAffix`, `isKeepAlive`, `tag`) VALUES ('0194c07e-a86e-7c25-8943-d6e330dae422', '2025-02-01 15:51:53.711', '2025-02-01 15:52:18.039', NULL, '0194c07e-4e3d-7441-a7dd-47e225bf0d4b', 0, 'https://baidu.com', '百度', NULL, '', '', '百度', NULL, 'link', 0, 0, 0, 0, NULL);
INSERT INTO `sys_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `menu_parent_id`, `menu_sort`, `path`, `name`, `redirect`, `component`, `icon`, `title`, `active`, `type`, `isHide`, `isFull`, `isAffix`, `isKeepAlive`, `tag`) VALUES ('0194c07f-0f46-7a35-ba25-e08d2d3b3f97', '2025-02-01 15:52:20.039', '2025-02-01 15:52:38.530', NULL, '0194c07e-4e3d-7441-a7dd-47e225bf0d4b', 1, 'https://www.google.cn', '谷歌', NULL, '', '', '谷歌', NULL, 'link', 0, 0, 0, 0, NULL);
INSERT INTO `sys_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `menu_parent_id`, `menu_sort`, `path`, `name`, `redirect`, `component`, `icon`, `title`, `active`, `type`, `isHide`, `isFull`, `isAffix`, `isKeepAlive`, `tag`) VALUES ('0194c07f-9cea-787b-a68c-a64bf794876a', '2025-02-01 15:52:56.299', '2025-02-01 15:53:20.405', NULL, '0194c079-9d8c-7d4e-b342-bac26fd6157d', 5, '/Iframe', 'Iframe', NULL, '', 'el-icon-position', 'Iframe', NULL, 'menu', 0, 0, 0, 0, NULL);
INSERT INTO `sys_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `menu_parent_id`, `menu_sort`, `path`, `name`, `redirect`, `component`, `icon`, `title`, `active`, `type`, `isHide`, `isFull`, `isAffix`, `isKeepAlive`, `tag`) VALUES ('0194c080-050b-7318-b873-89af6043daf8', '2025-02-01 15:53:22.955', '2025-02-01 15:53:51.107', NULL, '0194c07f-9cea-787b-a68c-a64bf794876a', 0, 'https://v3.cn.vuejs.org', 'vue3', NULL, '', '', 'VUE 3', NULL, 'iframe', 0, 0, 0, 0, NULL);
INSERT INTO `sys_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `menu_parent_id`, `menu_sort`, `path`, `name`, `redirect`, `component`, `icon`, `title`, `active`, `type`, `isHide`, `isFull`, `isAffix`, `isKeepAlive`, `tag`) VALUES ('0194c080-7ad2-7ea2-9864-70b6afce1645', '2025-02-01 15:53:53.107', '2025-02-01 15:54:16.755', NULL, '0194c07f-9cea-787b-a68c-a64bf794876a', 1, 'https://element-plus.gitee.io', 'elementplus', NULL, '', '', 'Element Plus', NULL, 'iframe', 0, 0, 0, 0, NULL);
INSERT INTO `sys_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `menu_parent_id`, `menu_sort`, `path`, `name`, `redirect`, `component`, `icon`, `title`, `active`, `type`, `isHide`, `isFull`, `isAffix`, `isKeepAlive`, `tag`) VALUES ('0194c081-7227-7259-9734-de2ea3f8f2b0', '2025-02-01 15:54:56.423', '2025-02-08 15:10:27.285', NULL, '', 7, '/about', 'about', '', 'about/index', 'el-icon-info-filled', '关于', '', 'menu', 0, 0, 0, 0, '');
INSERT INTO `sys_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `menu_parent_id`, `menu_sort`, `path`, `name`, `redirect`, `component`, `icon`, `title`, `active`, `type`, `isHide`, `isFull`, `isAffix`, `isKeepAlive`, `tag`) VALUES ('0194c084-9700-73f7-829b-6af68946d898', '2025-02-01 15:58:22.464', '2025-02-01 16:01:59.003', '2025-02-08 15:09:13.764', '', 5, '/test', 'test', '', '', 'el-icon-mouse', '实验室', '', 'menu', 0, 0, 0, 0, '');
INSERT INTO `sys_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `menu_parent_id`, `menu_sort`, `path`, `name`, `redirect`, `component`, `icon`, `title`, `active`, `type`, `isHide`, `isFull`, `isAffix`, `isKeepAlive`, `tag`) VALUES ('0194c084-fd30-785c-924b-a36e235a64df', '2025-02-01 15:58:48.625', '2025-02-01 16:00:13.485', NULL, '0194c084-9700-73f7-829b-6af68946d898', 0, '/test/autocode', 'autocode', NULL, 'test/autocode/index', 'sc-icon-code', '代码生成器', NULL, 'menu', 0, 0, 0, 0, NULL);
INSERT INTO `sys_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `menu_parent_id`, `menu_sort`, `path`, `name`, `redirect`, `component`, `icon`, `title`, `active`, `type`, `isHide`, `isFull`, `isAffix`, `isKeepAlive`, `tag`) VALUES ('0194c086-935c-7d4a-b4da-0809c7f88dae', '2025-02-01 16:00:32.606', '2025-02-01 16:01:00.424', NULL, '0194c084-9700-73f7-829b-6af68946d898', 1, '/test/codebug', 'codebug', NULL, 'test/codebug', 'sc-icon-bug-line', '异常处理', NULL, 'menu', 0, 0, 0, 0, NULL);
INSERT INTO `sys_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `menu_parent_id`, `menu_sort`, `path`, `name`, `redirect`, `component`, `icon`, `title`, `active`, `type`, `isHide`, `isFull`, `isAffix`, `isKeepAlive`, `tag`) VALUES ('0194ea33-2e5a-7311-9419-025bb89e7bac', '2025-02-09 18:13:30.331', '2025-02-09 18:13:45.455', NULL, '4b5658c4-6e27-4783-97f7-c3afc7ccdfe6', 0, '/Sun Feb 09 2025 18:13:30 GMT+0800 (中国标准时间)', 'task:add', '', '', '', '新增', NULL, 'button', 0, 0, 0, 0, NULL);
INSERT INTO `sys_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `menu_parent_id`, `menu_sort`, `path`, `name`, `redirect`, `component`, `icon`, `title`, `active`, `type`, `isHide`, `isFull`, `isAffix`, `isKeepAlive`, `tag`) VALUES ('0194ea33-72e4-77df-b55e-f9d80fa11fe0', '2025-02-09 18:13:47.877', '2025-02-09 18:14:08.914', NULL, '4b5658c4-6e27-4783-97f7-c3afc7ccdfe6', 1, '/Sun Feb 09 2025 18:13:47 GMT+0800 (中国标准时间)', 'task:del:batch', '', '', '', '批量删除', NULL, 'button', 0, 0, 0, 0, NULL);
INSERT INTO `sys_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `menu_parent_id`, `menu_sort`, `path`, `name`, `redirect`, `component`, `icon`, `title`, `active`, `type`, `isHide`, `isFull`, `isAffix`, `isKeepAlive`, `tag`) VALUES ('0194ea97-0787-714f-b3fd-231c2e7fb569', '2025-02-09 20:02:33.992', '2025-02-09 20:02:43.133', NULL, '4b5658c4-6e27-4783-97f7-c3afc7ccdfe6', 2, '/Sun Feb 09 2025 20:02:33 GMT+0800 (中国标准时间)', 'task:info', '', '', '', '查看', NULL, 'button', 0, 0, 0, 0, NULL);
INSERT INTO `sys_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `menu_parent_id`, `menu_sort`, `path`, `name`, `redirect`, `component`, `icon`, `title`, `active`, `type`, `isHide`, `isFull`, `isAffix`, `isKeepAlive`, `tag`) VALUES ('0194ea97-70db-7da0-8b73-ca2ef8749ba3', '2025-02-09 20:03:00.956', '2025-02-09 20:03:07.326', NULL, '4b5658c4-6e27-4783-97f7-c3afc7ccdfe6', 3, '/Sun Feb 09 2025 20:03:00 GMT+0800 (中国标准时间)', 'task:edit', '', '', '', '编辑', NULL, 'button', 0, 0, 0, 0, NULL);
INSERT INTO `sys_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `menu_parent_id`, `menu_sort`, `path`, `name`, `redirect`, `component`, `icon`, `title`, `active`, `type`, `isHide`, `isFull`, `isAffix`, `isKeepAlive`, `tag`) VALUES ('0194ea97-c8da-7f2a-8b5d-cd132bcc1377', '2025-02-09 20:03:23.483', '2025-02-09 20:03:33.857', NULL, '4b5658c4-6e27-4783-97f7-c3afc7ccdfe6', 4, '/Sun Feb 09 2025 20:03:23 GMT+0800 (中国标准时间)', 'task:del', '', '', '', '删除', NULL, 'button', 0, 0, 0, 0, NULL);
INSERT INTO `sys_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `menu_parent_id`, `menu_sort`, `path`, `name`, `redirect`, `component`, `icon`, `title`, `active`, `type`, `isHide`, `isFull`, `isAffix`, `isKeepAlive`, `tag`) VALUES ('0194ea98-6088-74c2-b728-626d4e53c011', '2025-02-09 20:04:02.312', '2025-02-09 20:04:11.289', NULL, '4b5658c4-6e27-4783-97f7-c3afc7ccdfe6', 5, '/Sun Feb 09 2025 20:04:02 GMT+0800 (中国标准时间)', 'task:run', '', '', '', '运行一次', NULL, 'button', 0, 0, 0, 0, NULL);
INSERT INTO `sys_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `menu_parent_id`, `menu_sort`, `path`, `name`, `redirect`, `component`, `icon`, `title`, `active`, `type`, `isHide`, `isFull`, `isAffix`, `isKeepAlive`, `tag`) VALUES ('15b7f208-9af1-463f-81ac-4154927659f6', '2024-12-19 13:09:08.899', '2025-02-08 14:28:13.661', NULL, '449bc9fc-9cc1-11ef-ae8b-4aa14d9c28f0', 1, '/settings/dept', 'settingDept', '', 'setting/dept/index', 'Sailor-icon-organization', '部门管理', '', 'menu', 0, 0, 0, 0, '');
INSERT INTO `sys_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `menu_parent_id`, `menu_sort`, `path`, `name`, `redirect`, `component`, `icon`, `title`, `active`, `type`, `isHide`, `isFull`, `isAffix`, `isKeepAlive`, `tag`) VALUES ('1637386b-ce8d-4b08-9fc7-36fc7cd04a3f', '2024-11-07 17:30:08.842', '2025-01-31 03:18:41.672', NULL, '449acc8c-9cc1-11ef-ae8b-4aa14d9c28f0', 1, '/userCenter', 'userCenter', '', 'userCenter/index', 'el-icon-user', '个人中心', '', 'menu', 0, 0, 0, 0, '');
INSERT INTO `sys_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `menu_parent_id`, `menu_sort`, `path`, `name`, `redirect`, `component`, `icon`, `title`, `active`, `type`, `isHide`, `isFull`, `isAffix`, `isKeepAlive`, `tag`) VALUES ('3dd8c086-f4f6-4d96-8dab-ce90aff35457', '2024-11-07 18:29:45.838', '2025-01-31 03:19:28.090', NULL, '449bc9fc-9cc1-11ef-ae8b-4aa14d9c28f0', 2, '/setting/user', 'settingUser', '', 'setting/user/index', 'el-icon-user', '用户管理', '', 'menu', 0, 0, 0, 0, '');
INSERT INTO `sys_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `menu_parent_id`, `menu_sort`, `path`, `name`, `redirect`, `component`, `icon`, `title`, `active`, `type`, `isHide`, `isFull`, `isAffix`, `isKeepAlive`, `tag`) VALUES ('449acc8c-9cc1-11ef-ae8b-4aa14d9c28f0', '2024-11-07 09:21:20.094', '2025-01-31 19:26:48.192', NULL, '', 0, '/home', 'home', '', 'home/index', 'el-icon-home-filled', '首页', '', 'menu', 0, 0, 0, 0, '');
INSERT INTO `sys_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `menu_parent_id`, `menu_sort`, `path`, `name`, `redirect`, `component`, `icon`, `title`, `active`, `type`, `isHide`, `isFull`, `isAffix`, `isKeepAlive`, `tag`) VALUES ('449bc286-9cc1-11ef-ae8b-4aa14d9c28f0', '2024-11-07 09:21:20.094', '2025-01-31 03:19:50.824', NULL, '449bc9fc-9cc1-11ef-ae8b-4aa14d9c28f0', 3, '/setting/role', 'settingRole', '', 'setting/role/index', 'el-icon-notebook', '角色管理', '', 'menu', 0, 0, 0, 0, '');
INSERT INTO `sys_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `menu_parent_id`, `menu_sort`, `path`, `name`, `redirect`, `component`, `icon`, `title`, `active`, `type`, `isHide`, `isFull`, `isAffix`, `isKeepAlive`, `tag`) VALUES ('449bc9fc-9cc1-11ef-ae8b-4aa14d9c28f0', '2024-11-07 09:21:20.094', '2025-02-01 16:02:02.931', NULL, '', 6, '/setting', 'setting', '', 'setting/index', 'el-icon-setting', '设置', '', 'menu', 0, 0, 0, 0, '');
INSERT INTO `sys_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `menu_parent_id`, `menu_sort`, `path`, `name`, `redirect`, `component`, `icon`, `title`, `active`, `type`, `isHide`, `isFull`, `isAffix`, `isKeepAlive`, `tag`) VALUES ('449bd064-9cc1-11ef-ae8b-4aa14d9c28f0', '2024-11-07 09:21:20.094', '2025-01-31 03:20:02.095', NULL, '449bc9fc-9cc1-11ef-ae8b-4aa14d9c28f0', 4, '/setting/dict', 'settingDict', '', 'setting/dict/index', 'el-icon-document', '字典管理', '', 'menu', 0, 0, 0, 0, '');
INSERT INTO `sys_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `menu_parent_id`, `menu_sort`, `path`, `name`, `redirect`, `component`, `icon`, `title`, `active`, `type`, `isHide`, `isFull`, `isAffix`, `isKeepAlive`, `tag`) VALUES ('449bd3a2-9cc1-11ef-ae8b-4aa14d9c28f0', '2024-11-07 09:21:20.094', '2025-01-31 03:19:20.543', NULL, '449bc9fc-9cc1-11ef-ae8b-4aa14d9c28f0', 0, '/setting/menu', 'settingMenu', '', 'setting/menu/index', 'el-icon-menu', '菜单管理', '', 'menu', 0, 0, 0, 0, '');
INSERT INTO `sys_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `menu_parent_id`, `menu_sort`, `path`, `name`, `redirect`, `component`, `icon`, `title`, `active`, `type`, `isHide`, `isFull`, `isAffix`, `isKeepAlive`, `tag`) VALUES ('449bdcee-9cc1-11ef-ae8b-4aa14d9c28f0', '2024-11-07 09:21:20.094', '2025-01-31 03:20:55.967', NULL, '449bc9fc-9cc1-11ef-ae8b-4aa14d9c28f0', 5, '/setting/apis', 'settingApis', '', 'setting/apis/index', 'el-icon-paperclip', '接口管理', '', 'menu', 0, 0, 0, 0, '');
INSERT INTO `sys_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `menu_parent_id`, `menu_sort`, `path`, `name`, `redirect`, `component`, `icon`, `title`, `active`, `type`, `isHide`, `isFull`, `isAffix`, `isKeepAlive`, `tag`) VALUES ('4b5658c4-6e27-4783-97f7-c3afc7ccdfe6', '2024-12-20 10:10:23.456', '2025-02-08 17:31:24.807', NULL, '', 4, '/task', 'task', '', 'task/index', 'el-icon-alarm-clock', '任务调度', '', 'menu', 0, 0, 0, 0, '');
INSERT INTO `sys_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `menu_parent_id`, `menu_sort`, `path`, `name`, `redirect`, `component`, `icon`, `title`, `active`, `type`, `isHide`, `isFull`, `isAffix`, `isKeepAlive`, `tag`) VALUES ('6e201dfe-c24b-4e26-9edd-aa831bb096f5', '2024-12-17 13:07:03.789', '2025-01-31 03:21:09.556', NULL, '449bc9fc-9cc1-11ef-ae8b-4aa14d9c28f0', 6, '/log', 'settingLog', '', 'setting/log/index', 'el-icon-document-copy', '系统日志', '', 'menu', 0, 0, 0, 0, '');
INSERT INTO `sys_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `menu_parent_id`, `menu_sort`, `path`, `name`, `redirect`, `component`, `icon`, `title`, `active`, `type`, `isHide`, `isFull`, `isAffix`, `isKeepAlive`, `tag`) VALUES ('8bbb326f-0688-488f-8111-ecaf137d31eb', '2024-11-07 17:28:02.904', '2025-01-31 03:18:22.477', NULL, '449acc8c-9cc1-11ef-ae8b-4aa14d9c28f0', 0, '/dashboard', 'dashboard', '', 'home/index', 'el-icon-data-line', '控制台', '', 'menu', 0, 0, 1, 0, '');
INSERT INTO `sys_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `menu_parent_id`, `menu_sort`, `path`, `name`, `redirect`, `component`, `icon`, `title`, `active`, `type`, `isHide`, `isFull`, `isAffix`, `isKeepAlive`, `tag`) VALUES ('edbb31bd-de10-4205-bbbc-bed2d4487616', '2024-12-26 15:58:15.710', '2025-01-31 03:22:45.758', NULL, '8bbb326f-0688-488f-8111-ecaf137d31eb', 0, '', 'home:customize', '', '', '', '自定义', '', 'button', 0, 0, 0, 0, '');
COMMIT;

-- ----------------------------
-- Table structure for sys_operation_log
-- ----------------------------
DROP TABLE IF EXISTS `sys_operation_log`;
CREATE TABLE `sys_operation_log` (
  `uuid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '操作记录唯一ID',
  `created_at` datetime(3) DEFAULT NULL,
  `updated_at` datetime(3) DEFAULT NULL,
  `deleted_at` datetime(3) DEFAULT NULL,
  `ip` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'IP地址',
  `method` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '请求方式',
  `path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '请求路径地址',
  `agent` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '代理',
  `request` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '请求参数',
  `response` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '响应结果',
  `code` tinyint unsigned DEFAULT NULL COMMENT '响应状态码',
  `administrator_id` bigint unsigned DEFAULT NULL COMMENT '管理员ID',
  PRIMARY KEY (`uuid`) USING BTREE,
  KEY `idx_sys_operation_log_administrator_id` (`administrator_id`),
  KEY `idx_sys_operation_log_deleted_at` (`deleted_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records of sys_operation_log
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_role`;
CREATE TABLE `sys_role` (
  `uuid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '角色唯一ID',
  `created_at` datetime(3) DEFAULT NULL COMMENT '创建时间',
  `updated_at` datetime(3) DEFAULT NULL COMMENT '修改时间',
  `deleted_at` datetime(3) DEFAULT NULL COMMENT '删除时间',
  `role_name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '角色名称',
  `role_code` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '角色编码',
  `role_notes` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注',
  `role_status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '角色状态0禁用，1正常',
  `role_sort` int NOT NULL DEFAULT '1' COMMENT '角色排序',
  PRIMARY KEY (`uuid`,`role_code`) USING BTREE,
  UNIQUE KEY `uni_sys_role_name` (`role_name`),
  UNIQUE KEY `uni_sys_role_code` (`role_code`),
  KEY `idx_sys_role_deleted_at` (`deleted_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records of sys_role
-- ----------------------------
BEGIN;
INSERT INTO `sys_role` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `role_name`, `role_code`, `role_notes`, `role_status`, `role_sort`) VALUES ('01948782-87d3-7d79-af28-59333e817553', '2025-01-21 14:17:46.196', '2025-01-31 11:50:01.423', NULL, '测试角色', 'test', '测试角色', 0, 1);
INSERT INTO `sys_role` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `role_name`, `role_code`, `role_notes`, `role_status`, `role_sort`) VALUES ('0194bb05-a190-738a-a0ac-655cfa708497', '2025-01-31 14:21:36.016', '2025-01-31 14:21:36.016', NULL, '测试角色2', 'test2', '', 1, 1);
INSERT INTO `sys_role` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `role_name`, `role_code`, `role_notes`, `role_status`, `role_sort`) VALUES ('0194bb06-d28c-7ee8-86a8-9920b3744c19', '2025-01-31 14:22:54.093', '2025-01-31 14:22:54.093', NULL, '测试角色3', 'test3', '', 1, 1);
INSERT INTO `sys_role` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `role_name`, `role_code`, `role_notes`, `role_status`, `role_sort`) VALUES ('1c4db252-318a-48f3-9693-f99cafa72426', '2024-12-15 16:05:02.814', '2025-01-21 14:11:19.040', NULL, '普通用户', 'user', '普通权限用户', 1, 1);
INSERT INTO `sys_role` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `role_name`, `role_code`, `role_notes`, `role_status`, `role_sort`) VALUES ('4db9e99c-9cc1-11ef-ae8b-4aa14d9c28f0', '2024-11-07 09:21:20.091', '2025-01-31 11:46:22.928', NULL, '超级管理员', 'super_admin', '拥有系统最高权限', 1, 0);
COMMIT;

-- ----------------------------
-- Table structure for sys_role_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_menu`;
CREATE TABLE `sys_role_menu` (
  `uuid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '角色菜单关联唯一ID',
  `created_at` datetime(3) DEFAULT NULL COMMENT '创建时间',
  `updated_at` datetime(3) DEFAULT NULL COMMENT '修改时间',
  `deleted_at` datetime(3) DEFAULT NULL COMMENT '删除时间',
  `role_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '角色编码',
  `menu_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '菜单ID',
  PRIMARY KEY (`uuid`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records of sys_role_menu
-- ----------------------------
BEGIN;
INSERT INTO `sys_role_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `role_code`, `menu_id`) VALUES ('03223188-2743-462f-8fc5-108680cb7e04', '2025-02-09 20:04:24.609', '2025-02-09 20:04:24.609', NULL, 'super_admin', '0194ba87-b24c-7d9c-8285-7c08e3aee75f');
INSERT INTO `sys_role_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `role_code`, `menu_id`) VALUES ('0608cdd2-53a7-414b-ac26-531ad1bfef33', '2025-01-22 11:00:36.584', '2025-01-22 11:00:36.584', NULL, 'user', '1637386b-ce8d-4b08-9fc7-36fc7cd04a3f');
INSERT INTO `sys_role_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `role_code`, `menu_id`) VALUES ('086eab14-967f-4734-b644-abb677268217', '2025-02-09 20:04:24.611', '2025-02-09 20:04:24.611', NULL, 'super_admin', '449bdcee-9cc1-11ef-ae8b-4aa14d9c28f0');
INSERT INTO `sys_role_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `role_code`, `menu_id`) VALUES ('0900d90a-c515-42e8-8078-69094e962d35', '2025-02-09 20:04:24.597', '2025-02-09 20:04:24.597', NULL, 'super_admin', '8bbb326f-0688-488f-8111-ecaf137d31eb');
INSERT INTO `sys_role_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `role_code`, `menu_id`) VALUES ('0cb62d14-a615-4f7e-b146-13b9bfa391b6', '2025-02-09 20:04:24.599', '2025-02-09 20:04:24.599', NULL, 'super_admin', '0194ea97-0787-714f-b3fd-231c2e7fb569');
INSERT INTO `sys_role_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `role_code`, `menu_id`) VALUES ('0e301d34-9df7-4f1d-951e-08ba0116c58f', '2025-02-09 20:04:24.602', '2025-02-09 20:04:24.602', NULL, 'super_admin', '0194bb0d-f3d1-71f7-9719-200d98ec196d');
INSERT INTO `sys_role_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `role_code`, `menu_id`) VALUES ('0f65adef-4bd7-420b-9a2e-375f7e2a5de6', '2025-01-22 11:00:36.583', '2025-01-22 11:00:36.583', NULL, 'user', '8bbb326f-0688-488f-8111-ecaf137d31eb');
INSERT INTO `sys_role_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `role_code`, `menu_id`) VALUES ('0fc94827-9907-4e2e-ac6e-cc768557e935', '2025-02-09 20:04:24.599', '2025-02-09 20:04:24.599', NULL, 'super_admin', '0194ea97-70db-7da0-8b73-ca2ef8749ba3');
INSERT INTO `sys_role_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `role_code`, `menu_id`) VALUES ('10d56438-346f-4da5-85ca-c95d987a65ea', '2025-02-09 20:04:24.602', '2025-02-09 20:04:24.602', NULL, 'super_admin', '15b7f208-9af1-463f-81ac-4154927659f6');
INSERT INTO `sys_role_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `role_code`, `menu_id`) VALUES ('181a1f86-06da-44cc-9049-24fa48b3efe1', '2025-02-09 20:04:24.597', '2025-02-09 20:04:24.597', NULL, 'super_admin', 'edbb31bd-de10-4205-bbbc-bed2d4487616');
INSERT INTO `sys_role_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `role_code`, `menu_id`) VALUES ('216c789f-bd5c-4581-a52b-22457781665c', '2025-02-09 20:04:24.599', '2025-02-09 20:04:24.599', NULL, 'super_admin', '0194ea33-72e4-77df-b55e-f9d80fa11fe0');
INSERT INTO `sys_role_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `role_code`, `menu_id`) VALUES ('2282f38d-680d-4bd1-930f-01e9c4e77446', '2025-01-22 11:00:36.585', '2025-01-22 11:00:36.585', NULL, 'user', 'f4f5e6fa-2183-494b-b3ab-39150127087f');
INSERT INTO `sys_role_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `role_code`, `menu_id`) VALUES ('233f2946-3486-413a-a054-6ad53cc74bb4', '2025-02-09 20:04:24.610', '2025-02-09 20:04:24.610', NULL, 'super_admin', '0194bb11-46ec-7334-b1d7-dbff10fd38cf');
INSERT INTO `sys_role_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `role_code`, `menu_id`) VALUES ('2755b80d-c98b-4a27-8f81-4bf8b592901c', '2025-02-09 20:04:24.602', '2025-02-09 20:04:24.602', NULL, 'super_admin', '3dd8c086-f4f6-4d96-8dab-ce90aff35457');
INSERT INTO `sys_role_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `role_code`, `menu_id`) VALUES ('2a6a65bd-3611-4ad5-beb9-2b9662bdbd0c', '2025-02-09 20:04:24.597', '2025-02-09 20:04:24.597', NULL, 'super_admin', '1637386b-ce8d-4b08-9fc7-36fc7cd04a3f');
INSERT INTO `sys_role_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `role_code`, `menu_id`) VALUES ('2d3a0bd0-216b-47d0-87c5-5cdc5b173a67', '2025-02-09 20:04:24.608', '2025-02-09 20:04:24.608', NULL, 'super_admin', '0194ba87-1829-79d3-8ef9-9bdb698ddc63');
INSERT INTO `sys_role_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `role_code`, `menu_id`) VALUES ('37dfd7a7-feda-4105-a820-dcc7653f62f8', '2025-02-09 20:04:24.600', '2025-02-09 20:04:24.600', NULL, 'super_admin', '449bc9fc-9cc1-11ef-ae8b-4aa14d9c28f0');
INSERT INTO `sys_role_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `role_code`, `menu_id`) VALUES ('391925e9-f1f8-4a23-ae3b-499deae9776c', '2025-02-09 20:04:24.606', '2025-02-09 20:04:24.606', NULL, 'super_admin', '0194ba7e-9787-7b7d-82d0-732c98056820');
INSERT INTO `sys_role_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `role_code`, `menu_id`) VALUES ('4256357f-2f03-41f5-b2e6-8f92a5f65ddb', '2025-02-09 20:04:24.606', '2025-02-09 20:04:24.606', NULL, 'super_admin', '0194ba7e-31b8-79ee-9201-fef455d70995');
INSERT INTO `sys_role_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `role_code`, `menu_id`) VALUES ('42a508b1-604b-4513-9186-36f4ab92a546', '2025-02-09 20:04:24.601', '2025-02-09 20:04:24.601', NULL, 'super_admin', '0194bb19-050b-7f1f-a2cb-3eab5225d206');
INSERT INTO `sys_role_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `role_code`, `menu_id`) VALUES ('4ed09488-ff52-40c0-a7dc-0c5c816f82f7', '2025-02-09 20:04:24.604', '2025-02-09 20:04:24.604', NULL, 'super_admin', '0194bb10-3e92-7cf8-aa6c-a7d1b45cf927');
INSERT INTO `sys_role_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `role_code`, `menu_id`) VALUES ('5031c76b-2979-4752-b70a-e13a4fe0c70e', '2025-02-09 20:04:24.598', '2025-02-09 20:04:24.598', NULL, 'super_admin', '0194ea33-2e5a-7311-9419-025bb89e7bac');
INSERT INTO `sys_role_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `role_code`, `menu_id`) VALUES ('56058dfc-2278-4611-b614-0d1cb82168db', '2025-02-09 20:04:24.611', '2025-02-09 20:04:24.611', NULL, 'super_admin', '449bd064-9cc1-11ef-ae8b-4aa14d9c28f0');
INSERT INTO `sys_role_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `role_code`, `menu_id`) VALUES ('64770ab0-5f19-4573-8116-8fc4a8541226', '2025-02-09 20:04:24.603', '2025-02-09 20:04:24.603', NULL, 'super_admin', '0194bb0f-0907-7065-be18-4feb1227a029');
INSERT INTO `sys_role_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `role_code`, `menu_id`) VALUES ('6e3cf9ad-c0b8-4c79-ab58-fc47d6a755b5', '2025-02-09 20:04:24.604', '2025-02-09 20:04:24.604', NULL, 'super_admin', '0194bb12-798a-7ea6-95cb-3313909e3f7d');
INSERT INTO `sys_role_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `role_code`, `menu_id`) VALUES ('880c7445-8f23-4a33-8fa1-f192ff046e39', '2025-02-09 20:04:24.596', '2025-02-09 20:04:24.596', NULL, 'super_admin', '449acc8c-9cc1-11ef-ae8b-4aa14d9c28f0');
INSERT INTO `sys_role_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `role_code`, `menu_id`) VALUES ('8ed03b9e-4d76-4a62-83c0-21a5d0481d45', '2025-02-09 20:04:24.605', '2025-02-09 20:04:24.605', NULL, 'super_admin', '449bc286-9cc1-11ef-ae8b-4aa14d9c28f0');
INSERT INTO `sys_role_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `role_code`, `menu_id`) VALUES ('8f4f2a7b-2a2e-4ced-821d-cdf29e12410b', '2025-02-09 20:04:24.612', '2025-02-09 20:04:24.612', NULL, 'super_admin', '0194c081-7227-7259-9734-de2ea3f8f2b0');
INSERT INTO `sys_role_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `role_code`, `menu_id`) VALUES ('90bf0df4-8e90-4e3f-acf6-7f84be62eefd', '2025-02-09 20:04:24.607', '2025-02-09 20:04:24.607', NULL, 'super_admin', '0194ba7f-b65a-7df2-8cdf-bfcc4401c035');
INSERT INTO `sys_role_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `role_code`, `menu_id`) VALUES ('9693a28d-68df-460e-928c-c488a6219ca7', '2025-02-09 20:04:24.601', '2025-02-09 20:04:24.601', NULL, 'super_admin', '0194bb19-cf5f-7a0e-8dba-261c5a0ea5b9');
INSERT INTO `sys_role_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `role_code`, `menu_id`) VALUES ('ac7aa371-649b-465a-bad8-b9df1fd83257', '2025-02-09 20:04:24.601', '2025-02-09 20:04:24.601', NULL, 'super_admin', '449bd3a2-9cc1-11ef-ae8b-4aa14d9c28f0');
INSERT INTO `sys_role_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `role_code`, `menu_id`) VALUES ('b1d5e6e2-d13f-41f8-a995-5f30463ebe27', '2025-02-09 20:04:24.605', '2025-02-09 20:04:24.605', NULL, 'super_admin', '0194bb14-4341-7d98-8ed0-ef671abb8d3a');
INSERT INTO `sys_role_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `role_code`, `menu_id`) VALUES ('b2d86fa6-3faa-4d6f-b2d7-f191c8c49f8c', '2025-02-09 20:04:24.603', '2025-02-09 20:04:24.603', NULL, 'super_admin', '0194bb10-e2a6-7157-895c-a0a9334ee7b4');
INSERT INTO `sys_role_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `role_code`, `menu_id`) VALUES ('b5997742-5e3a-41a0-8a1d-eceeabd84f30', '2025-02-09 20:04:24.604', '2025-02-09 20:04:24.604', NULL, 'super_admin', '0194bb0f-9a8a-7e67-bae3-5fbdeee6cd4e');
INSERT INTO `sys_role_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `role_code`, `menu_id`) VALUES ('d060ae5f-72b6-4be3-98fa-380118698329', '2025-02-09 20:04:24.612', '2025-02-09 20:04:24.612', NULL, 'super_admin', '6e201dfe-c24b-4e26-9edd-aa831bb096f5');
INSERT INTO `sys_role_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `role_code`, `menu_id`) VALUES ('d63eefc3-e12d-4683-90fb-1e07db6c31bf', '2025-02-09 20:04:24.600', '2025-02-09 20:04:24.600', NULL, 'super_admin', '0194ea98-6088-74c2-b728-626d4e53c011');
INSERT INTO `sys_role_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `role_code`, `menu_id`) VALUES ('d6423f4a-c32a-49ce-a994-90cfa53a806b', '2025-01-22 11:00:36.580', '2025-01-22 11:00:36.580', NULL, 'user', '449acc8c-9cc1-11ef-ae8b-4aa14d9c28f0');
INSERT INTO `sys_role_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `role_code`, `menu_id`) VALUES ('e28d5af3-7308-4328-bdf0-f5fed77e59d0', '2025-02-09 20:04:24.612', '2025-02-09 20:04:24.612', NULL, 'super_admin', '0194bafb-f847-75f3-a055-20f3d1fac851');
INSERT INTO `sys_role_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `role_code`, `menu_id`) VALUES ('eb1dafbe-b608-4bb4-af8f-a42a39a33d12', '2025-02-09 20:04:24.600', '2025-02-09 20:04:24.600', NULL, 'super_admin', '0194ea97-c8da-7f2a-8b5d-cd132bcc1377');
INSERT INTO `sys_role_menu` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `role_code`, `menu_id`) VALUES ('f8fe74d2-b488-4319-8b96-b8350ccaee93', '2025-02-09 20:04:24.598', '2025-02-09 20:04:24.598', NULL, 'super_admin', '4b5658c4-6e27-4783-97f7-c3afc7ccdfe6');
COMMIT;

-- ----------------------------
-- Table structure for sys_task
-- ----------------------------
DROP TABLE IF EXISTS `sys_task`;
CREATE TABLE `sys_task` (
  `uuid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '任务uuid',
  `created_at` datetime(3) DEFAULT NULL COMMENT '创建时间',
  `updated_at` datetime(3) DEFAULT NULL COMMENT '更新时间',
  `deleted_at` datetime(3) DEFAULT NULL COMMENT '删除时间',
  `task_name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '任务名称',
  `task_group` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '任务分组',
  `task_cron` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'cron表达式',
  `task_invoke_target` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '调用目标',
  `task_args` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '调用参数',
  `task_http_method` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'http请求方法',
  `task_timeout` bigint DEFAULT NULL COMMENT '任务执行超时时间(单位秒),0不限制',
  `task_multi` tinyint unsigned NOT NULL COMMENT '是否允许多实例运行0不允许，1允许',
  `task_retry_times` tinyint DEFAULT NULL COMMENT '重试次数',
  `task_retry_interval` bigint DEFAULT NULL COMMENT '重试间隔时间',
  `task_tag` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '任务类型:httpTask(HTTP任务),internalFuncTask(内部函数任务),shellTask(shell任务)',
  `task_remark` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `task_status` tinyint unsigned NOT NULL COMMENT 'Disabled int = 99 // 禁用\nEnabled  int = 1  // 启用',
  PRIMARY KEY (`uuid`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records of sys_task
-- ----------------------------
BEGIN;
INSERT INTO `sys_task` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `task_name`, `task_group`, `task_cron`, `task_invoke_target`, `task_args`, `task_http_method`, `task_timeout`, `task_multi`, `task_retry_times`, `task_retry_interval`, `task_tag`, `task_remark`, `task_status`) VALUES ('0fa1ef05-e63d-4455-8eba-b159d0cdac3a', '2025-01-01 19:36:37.000', '2025-02-09 20:28:26.631', NULL, '测试内部方法任务', 'test', '0 0/1 * * * ? ', 'ExamplesOne', 'test', '', 0, 0, 0, 0, 'internalFuncTask', '测试任务', 99);
INSERT INTO `sys_task` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `task_name`, `task_group`, `task_cron`, `task_invoke_target`, `task_args`, `task_http_method`, `task_timeout`, `task_multi`, `task_retry_times`, `task_retry_interval`, `task_tag`, `task_remark`, `task_status`) VALUES ('a97c2786-5a5c-432a-a8b5-56033dd777e1', '2025-01-02 17:33:11.899', '2025-01-02 17:33:11.899', NULL, '测试HTTP任务', 'http', '* 0/1 * * * ?', 'http://localhost:2900/aaa', 'a', 'GET', 4, 1, 3, 3, 'httpTask', '测试HTTP任务', 99);
COMMIT;

-- ----------------------------
-- Table structure for sys_task_log
-- ----------------------------
DROP TABLE IF EXISTS `sys_task_log`;
CREATE TABLE `sys_task_log` (
  `uuid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '日志uuid',
  `created_at` datetime(3) DEFAULT NULL COMMENT '创建时间',
  `updated_at` datetime(3) DEFAULT NULL COMMENT '更新时间',
  `deleted_at` datetime(3) DEFAULT NULL COMMENT '删除时间',
  `task_uuid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '任务uuid',
  `task_name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '任务名称',
  `task_cron` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '任务cron',
  `task_invoke_target` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '调用目标',
  `task_timeout` bigint DEFAULT NULL COMMENT '任务执行超时时间(单位秒),0不限制',
  `task_retry_times` tinyint DEFAULT NULL COMMENT '重试次数',
  `task_start_time` datetime(3) DEFAULT NULL COMMENT '任务开始时间',
  `task_end_time` datetime(3) DEFAULT NULL COMMENT '任务结束时间',
  `task_status` tinyint DEFAULT NULL COMMENT 'Running  int = 10 // 运行中\nFinish   int = 2  // 完成\nCancel   int = 3  // 取消\nFailure  int = 0  // 失败',
  `task_result` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '任务执行结果',
  `task_total_time` mediumint DEFAULT NULL COMMENT '任务执行总耗时(单位秒)',
  PRIMARY KEY (`uuid`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records of sys_task_log
-- ----------------------------
BEGIN;
INSERT INTO `sys_task_log` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `task_uuid`, `task_name`, `task_cron`, `task_invoke_target`, `task_timeout`, `task_retry_times`, `task_start_time`, `task_end_time`, `task_status`, `task_result`, `task_total_time`) VALUES ('019429ec-6c73-70f2-898b-bf9e3548b78f', '2025-01-03 10:09:07.700', '2025-01-03 10:11:07.703', '2025-01-03 10:26:55.237', '0fa1ef05-e63d-4455-8eba-b159d0cdac3a', '测试任务', '0 0/1 * * * ? ', 'ExamplesOne', 0, 0, '2025-01-03 10:09:07.699', '2025-01-03 10:11:07.703', 2, 'success', 120);
INSERT INTO `sys_task_log` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `task_uuid`, `task_name`, `task_cron`, `task_invoke_target`, `task_timeout`, `task_retry_times`, `task_start_time`, `task_end_time`, `task_status`, `task_result`, `task_total_time`) VALUES ('019429ec-70da-73b5-917f-f34467f93a3f', '2025-01-03 10:09:08.826', '2025-01-03 10:11:08.828', '2025-01-03 10:26:54.864', '0fa1ef05-e63d-4455-8eba-b159d0cdac3a', '测试任务', '0 0/1 * * * ? ', 'ExamplesOne', 0, 0, '2025-01-03 10:09:08.826', '2025-01-03 10:11:08.827', 2, 'success', 120);
INSERT INTO `sys_task_log` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `task_uuid`, `task_name`, `task_cron`, `task_invoke_target`, `task_timeout`, `task_retry_times`, `task_start_time`, `task_end_time`, `task_status`, `task_result`, `task_total_time`) VALUES ('019429f4-b3dc-78fc-ba8a-fe0671de7c0a', '2025-01-03 10:18:10.278', '2025-01-03 10:20:10.292', '2025-01-03 10:26:54.528', '0fa1ef05-e63d-4455-8eba-b159d0cdac3a', '测试任务', '0 0/1 * * * ? ', 'ExamplesOne', 0, 0, '2025-01-03 10:18:10.269', '2025-01-03 10:20:10.291', 2, 'success', 120);
INSERT INTO `sys_task_log` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `task_uuid`, `task_name`, `task_cron`, `task_invoke_target`, `task_timeout`, `task_retry_times`, `task_start_time`, `task_end_time`, `task_status`, `task_result`, `task_total_time`) VALUES ('019429f4-ce9c-7b85-8289-08af5af844dc', '2025-01-03 10:18:17.117', '2025-01-03 10:20:17.118', '2025-01-03 10:26:54.128', '0fa1ef05-e63d-4455-8eba-b159d0cdac3a', '测试任务', '0 0/1 * * * ? ', 'ExamplesOne', 0, 0, '2025-01-03 10:18:17.117', '2025-01-03 10:20:17.117', 2, 'success', 120);
INSERT INTO `sys_task_log` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `task_uuid`, `task_name`, `task_cron`, `task_invoke_target`, `task_timeout`, `task_retry_times`, `task_start_time`, `task_end_time`, `task_status`, `task_result`, `task_total_time`) VALUES ('019429fc-fcb7-7ed4-97a8-b9e08fe344ec', '2025-01-03 10:27:13.208', '2025-01-03 10:29:13.219', '2025-01-04 22:54:09.101', '0fa1ef05-e63d-4455-8eba-b159d0cdac3a', '测试任务', '0 0/1 * * * ? ', 'ExamplesOne', 0, 0, '2025-01-03 10:27:13.208', '2025-01-03 10:29:13.211', 2, 'success', 120);
INSERT INTO `sys_task_log` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `task_uuid`, `task_name`, `task_cron`, `task_invoke_target`, `task_timeout`, `task_retry_times`, `task_start_time`, `task_end_time`, `task_status`, `task_result`, `task_total_time`) VALUES ('019429fd-0b04-7c38-8c46-5429cd11b85b', '2025-01-03 10:27:16.869', '2025-01-03 10:29:16.870', '2025-01-04 22:54:09.695', '0fa1ef05-e63d-4455-8eba-b159d0cdac3a', '测试任务', '0 0/1 * * * ? ', 'ExamplesOne', 0, 0, '2025-01-03 10:27:16.869', '2025-01-03 10:29:16.870', 2, 'success', 120);
INSERT INTO `sys_task_log` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `task_uuid`, `task_name`, `task_cron`, `task_invoke_target`, `task_timeout`, `task_retry_times`, `task_start_time`, `task_end_time`, `task_status`, `task_result`, `task_total_time`) VALUES ('01942a00-a0e1-7153-bdcd-cbafc7e979bc', '2025-01-03 10:31:11.842', '2025-01-03 10:33:11.853', '2025-01-04 22:54:10.007', '0fa1ef05-e63d-4455-8eba-b159d0cdac3a', '测试任务', '0 0/1 * * * ? ', 'ExamplesOne', 0, 0, '2025-01-03 10:31:11.842', '2025-01-03 10:33:11.852', 2, 'success', 120);
INSERT INTO `sys_task_log` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `task_uuid`, `task_name`, `task_cron`, `task_invoke_target`, `task_timeout`, `task_retry_times`, `task_start_time`, `task_end_time`, `task_status`, `task_result`, `task_total_time`) VALUES ('01942a00-a64e-7f3a-b7d3-140c95967c1b', '2025-01-03 10:31:13.232', '2025-01-03 10:33:13.234', '2025-01-04 22:54:10.234', '0fa1ef05-e63d-4455-8eba-b159d0cdac3a', '测试任务', '0 0/1 * * * ? ', 'ExamplesOne', 0, 0, '2025-01-03 10:31:13.232', '2025-01-03 10:33:13.234', 2, 'success', 120);
INSERT INTO `sys_task_log` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `task_uuid`, `task_name`, `task_cron`, `task_invoke_target`, `task_timeout`, `task_retry_times`, `task_start_time`, `task_end_time`, `task_status`, `task_result`, `task_total_time`) VALUES ('01942a00-a8b1-7d69-b023-2d19b01157a7', '2025-01-03 10:31:13.842', '2025-01-03 10:33:13.843', '2025-01-04 22:54:10.571', '0fa1ef05-e63d-4455-8eba-b159d0cdac3a', '测试任务', '0 0/1 * * * ? ', 'ExamplesOne', 0, 0, '2025-01-03 10:31:13.842', '2025-01-03 10:33:13.843', 2, 'success', 120);
INSERT INTO `sys_task_log` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `task_uuid`, `task_name`, `task_cron`, `task_invoke_target`, `task_timeout`, `task_retry_times`, `task_start_time`, `task_end_time`, `task_status`, `task_result`, `task_total_time`) VALUES ('01942a00-aa99-7e63-990f-55db223d716b', '2025-01-03 10:31:14.330', '2025-01-03 10:33:14.332', '2025-01-04 22:54:10.745', '0fa1ef05-e63d-4455-8eba-b159d0cdac3a', '测试任务', '0 0/1 * * * ? ', 'ExamplesOne', 0, 0, '2025-01-03 10:31:14.330', '2025-01-03 10:33:14.332', 2, 'success', 120);
INSERT INTO `sys_task_log` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `task_uuid`, `task_name`, `task_cron`, `task_invoke_target`, `task_timeout`, `task_retry_times`, `task_start_time`, `task_end_time`, `task_status`, `task_result`, `task_total_time`) VALUES ('01942a00-ab72-7dc7-9f2a-f32e71ad2204', '2025-01-03 10:31:14.549', '2025-01-03 10:33:14.552', '2025-01-04 22:54:10.917', '0fa1ef05-e63d-4455-8eba-b159d0cdac3a', '测试任务', '0 0/1 * * * ? ', 'ExamplesOne', 0, 0, '2025-01-03 10:31:14.547', '2025-01-03 10:33:14.551', 2, 'success', 120);
INSERT INTO `sys_task_log` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `task_uuid`, `task_name`, `task_cron`, `task_invoke_target`, `task_timeout`, `task_retry_times`, `task_start_time`, `task_end_time`, `task_status`, `task_result`, `task_total_time`) VALUES ('01942a00-ac64-7144-87ee-3042f7017310', '2025-01-03 10:31:14.788', '2025-01-03 10:33:14.790', '2025-01-04 22:54:11.154', '0fa1ef05-e63d-4455-8eba-b159d0cdac3a', '测试任务', '0 0/1 * * * ? ', 'ExamplesOne', 0, 0, '2025-01-03 10:31:14.788', '2025-01-03 10:33:14.790', 2, 'success', 120);
INSERT INTO `sys_task_log` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `task_uuid`, `task_name`, `task_cron`, `task_invoke_target`, `task_timeout`, `task_retry_times`, `task_start_time`, `task_end_time`, `task_status`, `task_result`, `task_total_time`) VALUES ('01942a02-d518-7222-8c3f-9e43c8dd27ac', '2025-01-03 10:33:36.284', '2025-01-03 10:35:36.290', '2025-01-04 22:54:11.386', '0fa1ef05-e63d-4455-8eba-b159d0cdac3a', '测试任务', '0 0/1 * * * ? ', 'ExamplesOne', 0, 0, '2025-01-03 10:33:36.280', '2025-01-03 10:35:36.289', 2, 'success', 120);
INSERT INTO `sys_task_log` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `task_uuid`, `task_name`, `task_cron`, `task_invoke_target`, `task_timeout`, `task_retry_times`, `task_start_time`, `task_end_time`, `task_status`, `task_result`, `task_total_time`) VALUES ('01942f21-8a2a-7e7e-b8fb-168b73f3db56', '2025-01-04 10:25:14.799', '2025-01-04 10:27:14.809', '2025-01-04 22:54:11.574', '0fa1ef05-e63d-4455-8eba-b159d0cdac3a', '测试任务', '0 0/1 * * * ? ', 'ExamplesOne', 0, 0, '2025-01-04 10:25:14.795', '2025-01-04 10:27:14.809', 2, 'success', 120);
INSERT INTO `sys_task_log` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `task_uuid`, `task_name`, `task_cron`, `task_invoke_target`, `task_timeout`, `task_retry_times`, `task_start_time`, `task_end_time`, `task_status`, `task_result`, `task_total_time`) VALUES ('0194309e-cbea-7aba-92b6-cc84e5495993', '2025-01-04 17:21:40.846', '2025-01-04 17:23:40.850', '2025-01-04 22:54:11.953', '0fa1ef05-e63d-4455-8eba-b159d0cdac3a', '测试任务', '0 0/1 * * * ? ', 'ExamplesOne', 0, 0, '2025-01-04 17:21:40.843', '2025-01-04 17:23:40.849', 2, 'success', 120);
INSERT INTO `sys_task_log` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `task_uuid`, `task_name`, `task_cron`, `task_invoke_target`, `task_timeout`, `task_retry_times`, `task_start_time`, `task_end_time`, `task_status`, `task_result`, `task_total_time`) VALUES ('019431cf-51f4-749f-926a-72eb6bc54c91', '2025-01-04 22:54:18.101', '2025-01-04 22:56:18.117', NULL, '0fa1ef05-e63d-4455-8eba-b159d0cdac3a', '测试任务', '0 0/1 * * * ? ', 'ExamplesOne', 0, 0, '2025-01-04 22:54:18.101', '2025-01-04 22:56:18.117', 2, 'success', 120);
INSERT INTO `sys_task_log` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `task_uuid`, `task_name`, `task_cron`, `task_invoke_target`, `task_timeout`, `task_retry_times`, `task_start_time`, `task_end_time`, `task_status`, `task_result`, `task_total_time`) VALUES ('019431e4-57e8-7392-823d-548144822a37', '2025-01-04 23:17:15.883', '2025-01-04 23:19:15.910', NULL, '0fa1ef05-e63d-4455-8eba-b159d0cdac3a', '测试任务', '0 0/1 * * * ? ', 'ExamplesOne', 0, 0, '2025-01-04 23:17:15.883', '2025-01-04 23:19:15.909', 2, 'success', 120);
INSERT INTO `sys_task_log` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `task_uuid`, `task_name`, `task_cron`, `task_invoke_target`, `task_timeout`, `task_retry_times`, `task_start_time`, `task_end_time`, `task_status`, `task_result`, `task_total_time`) VALUES ('019431f1-91cf-7bdb-87cc-7f31b56790b6', '2025-01-04 23:31:42.672', '2025-01-05 00:46:45.054', NULL, '0fa1ef05-e63d-4455-8eba-b159d0cdac3a', '测试任务', '0 0/1 * * * ? ', 'ExamplesOne', 0, 0, '2025-01-04 23:31:42.672', '2025-01-05 00:46:45.053', 2, 'success', 4502);
INSERT INTO `sys_task_log` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `task_uuid`, `task_name`, `task_cron`, `task_invoke_target`, `task_timeout`, `task_retry_times`, `task_start_time`, `task_end_time`, `task_status`, `task_result`, `task_total_time`) VALUES ('01944017-3b07-7203-8d1c-a4ee62e47fcc', '2025-01-07 17:27:31.854', '2025-01-07 17:28:31.879', NULL, '0fa1ef05-e63d-4455-8eba-b159d0cdac3a', '测试任务', '0 0/1 * * * ? ', 'ExamplesOne', 0, 0, '2025-01-07 17:27:31.847', '2025-01-07 17:28:31.878', 2, '', 0);
INSERT INTO `sys_task_log` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `task_uuid`, `task_name`, `task_cron`, `task_invoke_target`, `task_timeout`, `task_retry_times`, `task_start_time`, `task_end_time`, `task_status`, `task_result`, `task_total_time`) VALUES ('0194401e-11a1-7128-af4e-78203db771bc', '2025-01-07 17:35:00.019', '2025-01-07 17:36:00.037', NULL, '0fa1ef05-e63d-4455-8eba-b159d0cdac3a', '测试任务', '0 0/1 * * * ? ', 'ExamplesOne', 0, 0, '2025-01-07 17:35:00.001', '2025-01-07 17:36:00.037', 2, 'success', 60);
INSERT INTO `sys_task_log` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `task_uuid`, `task_name`, `task_cron`, `task_invoke_target`, `task_timeout`, `task_retry_times`, `task_start_time`, `task_end_time`, `task_status`, `task_result`, `task_total_time`) VALUES ('0194ea9f-5bec-7910-9a67-76f64c94ae2c', '2025-02-09 20:11:39.904', '2025-02-09 20:12:39.931', NULL, '0fa1ef05-e63d-4455-8eba-b159d0cdac3a', '测试任务', '0 0/1 * * * ? ', 'ExamplesOne', 0, 0, '2025-02-09 20:11:39.885', '2025-02-09 20:12:39.930', 2, 'success', 60);
INSERT INTO `sys_task_log` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `task_uuid`, `task_name`, `task_cron`, `task_invoke_target`, `task_timeout`, `task_retry_times`, `task_start_time`, `task_end_time`, `task_status`, `task_result`, `task_total_time`) VALUES ('0194eaae-d68a-7914-8409-5893ba3efb24', '2025-02-09 20:28:34.315', '2025-02-09 20:29:34.322', NULL, '0fa1ef05-e63d-4455-8eba-b159d0cdac3a', '测试内部方法任务', '0 0/1 * * * ? ', 'ExamplesOne', 0, 0, '2025-02-09 20:28:34.315', '2025-02-09 20:29:34.321', 2, 'success', 60);
INSERT INTO `sys_task_log` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `task_uuid`, `task_name`, `task_cron`, `task_invoke_target`, `task_timeout`, `task_retry_times`, `task_start_time`, `task_end_time`, `task_status`, `task_result`, `task_total_time`) VALUES ('0194ed87-18e3-7e48-a425-b546e3ea4628', '2025-02-10 09:44:01.509', '2025-02-10 09:44:10.544', NULL, 'a97c2786-5a5c-432a-a8b5-56033dd777e1', '测试HTTP任务', '* 0/1 * * * ?', 'http://localhost:2900/aaa', 4, 0, '2025-02-10 09:44:01.508', '2025-02-10 09:44:10.544', 0, '执行HTTP请求错误-Get \"http://localhost:2900/aaa\": dial tcp [::1]:2900: connect: connection refused', 9);
COMMIT;

-- ----------------------------
-- Table structure for sys_user
-- ----------------------------
DROP TABLE IF EXISTS `sys_user`;
CREATE TABLE `sys_user` (
  `uuid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '用户唯一ID',
  `created_at` datetime(3) DEFAULT NULL COMMENT '创建时间',
  `updated_at` datetime(3) DEFAULT NULL COMMENT '更新时间',
  `deleted_at` datetime(3) DEFAULT NULL,
  `user_mobile` char(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '用户手机号',
  `user_password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '用户密码',
  `user_email` varchar(25) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '用户邮箱',
  `user_name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '用户姓名',
  `user_avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '用户头像',
  `user_sex` tinyint(1) NOT NULL DEFAULT '1' COMMENT '用户性别0女1男',
  `user_status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '用户状态1正常，0禁用',
  `user_account` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '用户账号',
  `user_role` varchar(255) COLLATE utf8mb4_general_ci NOT NULL COMMENT '用户角色,字符串数组',
  PRIMARY KEY (`uuid`) USING BTREE,
  UNIQUE KEY `uni_sys_administrator_mobile` (`user_mobile`),
  UNIQUE KEY `uni_sys_administrator_email` (`user_email`),
  KEY `idx_sys_administrator_deleted_at` (`deleted_at`),
  KEY `idx_sys_administrator_mobile` (`user_mobile`),
  KEY `idx_sys_administrator_email` (`user_email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records of sys_user
-- ----------------------------
BEGIN;
INSERT INTO `sys_user` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `user_mobile`, `user_password`, `user_email`, `user_name`, `user_avatar`, `user_sex`, `user_status`, `user_account`, `user_role`) VALUES ('5384c108-9cc1-11ef-ae8b-4aa14d9c28f0', '2024-11-07 09:21:20.090', '2025-02-01 01:23:44.037', NULL, '18888888888', '$2a$04$NuLtzxtwtn5iuMPzFXo0pO1Y.xpTai8WsO1dr.JszfQglWFjokjFu', 'admin@admin.com', '超级管理员', '', 1, 1, 'admin', '[\"super_admin\",\"test\",\"user\",\"test2\",\"test3\"]');
INSERT INTO `sys_user` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `user_mobile`, `user_password`, `user_email`, `user_name`, `user_avatar`, `user_sex`, `user_status`, `user_account`, `user_role`) VALUES ('8e2cdecb-816c-4125-968e-a12822556326', '2025-01-22 10:56:56.078', '2025-02-01 01:23:52.886', NULL, '18888888889', '$2a$04$0j2qwSFjWFmvKZ.mYF465.AJQuQv1p52RmP6OPCXay6O4GgVlniy6', 'test@qq.com', '测试账号', '', 0, 1, 'test', '[\"user\"]');
INSERT INTO `sys_user` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `user_mobile`, `user_password`, `user_email`, `user_name`, `user_avatar`, `user_sex`, `user_status`, `user_account`, `user_role`) VALUES ('c3147e52-8b7f-4bb5-8333-a343a2c456dd', '2025-01-22 11:01:16.606', '2025-02-01 01:23:56.285', NULL, '13000000000', '$2a$04$w61ZCbVfD69htdqp88e.DuiYCndWl2aIAMg/ee9kHKVV512g0hhiC', 'user@qq.com', '普通用户', '', 0, 1, 'user', '[\"test\"]');
COMMIT;

-- ----------------------------
-- Table structure for sys_user_dashboard_grid
-- ----------------------------
DROP TABLE IF EXISTS `sys_user_dashboard_grid`;
CREATE TABLE `sys_user_dashboard_grid` (
  `uuid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '布局唯一ID',
  `created_at` datetime(3) DEFAULT NULL COMMENT '创建时间',
  `updated_at` datetime(3) DEFAULT NULL COMMENT '修改时间',
  `deleted_at` datetime(3) DEFAULT NULL COMMENT '删除时间',
  `user_uuid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '用户唯一标识',
  `component` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '组件标识',
  PRIMARY KEY (`uuid`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='用户控制台组件表';

-- ----------------------------
-- Records of sys_user_dashboard_grid
-- ----------------------------
BEGIN;
INSERT INTO `sys_user_dashboard_grid` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `user_uuid`, `component`) VALUES ('01948782-87d3-7d79-af28-59333e817553', '2025-01-21 14:17:46.196', '2025-01-21 14:19:40.415', NULL, '5384c108-9cc1-11ef-ae8b-4aa14d9c28f0', 'welcome');
INSERT INTO `sys_user_dashboard_grid` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `user_uuid`, `component`) VALUES ('1c4db252-318a-48f3-9693-f99cafa72426', '2024-12-15 16:05:02.814', '2025-01-21 14:11:19.040', NULL, '5384c108-9cc1-11ef-ae8b-4aa14d9c28f0', 'time');
INSERT INTO `sys_user_dashboard_grid` (`uuid`, `created_at`, `updated_at`, `deleted_at`, `user_uuid`, `component`) VALUES ('4db9e99c-9cc1-11ef-ae8b-4aa14d9c28f0', '2024-11-07 09:21:20.091', '2024-11-07 09:21:20.091', NULL, '5384c108-9cc1-11ef-ae8b-4aa14d9c28f0', 'progress');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
